I have a template with an opening dialog box that uses the date picker feature which displays a calendar. When the user selects a date from the calendar and the OK button is clicked, a bookmark in the document fills with the selected date. The default date format seems to be m/d/yyyy (1/2/2009), for example.
How and where do I reformat the DTPicker so the document's date displays January 2, 2009, for example? Here's the DTPicker code which inserts the date format described in first paragraph. Or, do I reformat the document's bookmark? If so, how?
Public Sub DTPicker1_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)
dtEffDate = Format(DTPicker1.Value, "MMMM d, YYYY")