How to format a date bookmark filled by DTPicker

[charlie6067]

Hi all,

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?

Thanks,
Charlie
charlie6067

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")

End Sub

[HansV]

I wouldn't use the CallbackKeyDown event of the datye/time picker, but the Change event:

Private Sub DTPicker1_Change()
  ActiveDocument.Bookmarks("SomeBookmark").Range.Text = _
	Format(Me.DTPicker1.Value, "MMMM d, YYYY")
End Sub

[charlie6067]

Thanks, Slinky, for the reply. Your suggestion worked great.

Charlie
charlie6067