 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / February 2005Setting language
How do you change language during execution of a UserForm. I want the result of a Date statement to be in English, but keep getting Dutch results. No doubt this is a result of the Application language, but the docuement is set to English VS. Me.Controls("Textbox8").Text = Format(Date, "Mmmm, d yyyy") You could always use Format(Date, "MMMM") & ", " & Format(Date, "d") & " " & Format(Date, "yyyy")  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > How do you change language during execution of a UserForm. > I want the result of a Date statement to be in English, but keep getting [quoted text clipped - 3 lines] > > Me.Controls("Textbox8").Text = Format(Date, "Mmmm, d yyyy") This is no solution. I want the date to show in English in the form: January, 15 2005. That's the normal format in English, isn't it? > You could always use > [quoted text clipped - 7 lines] > > > > Me.Controls("Textbox8").Text = Format(Date, "Mmmm, d yyyy") No, that's not any normal format that I am aware of. English would be 15 January 2005, maybe with a comma after the month, but not always. American would be January 15, 2005 Apart from in your post, I have never seen January, 15 2005. SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > This is no solution. I want the date to show in English in the form: > January, 15 2005. [quoted text clipped - 14 lines] >> > >> > Me.Controls("Textbox8").Text = Format(Date, "Mmmm, d yyyy") And if you need to show the date in a language format that's different from your regional settings, then this thread (using date fields in the document or string replacements) might help: http://groups.google.com/groups?selm=up7qxYiJEHA.556%40tk2msftngp13.phx.gbl Regards, Klaus |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.