Show Calenda

[byulogia@gmail.com]

I have a field named Date:



I want it to show calendar when the user click on it (for data control)

Please any help?

[ranman256]

in a text box in form design, properties, format tab, set SHOW DATE PICKER = for dates
same in table design for the field.

[moke123]

date is a reserved word. You should change it.

[byulogia@gmail.com]

Thanks for this.
I worked it out by going to the table design view, and change the data type to date, and the form shows calendar when I click on the field date.

[Missinglinq]

Also, if you would prefer the calendar to pop up when the Control receives Focus, without the user having to click on it, this bit of code will do that

Private Sub YourDateFieldName_GotFocus()
  DoCmd.RunCommand acCmdShowDatePicker
End Sub

To have it only pop up, on Focus, if the Textbox is empty

Private Sub YourDateFieldName_GotFocus()
 If Nz(Me.YourDateFieldName,"") = "" Then
  DoCmd.RunCommand acCmdShowDatePicker
 End If
End Sub

Replacing, of course, YourDateFieldName with the actual name of your Control...which, has been said, needs to be something other than Date...which is a Reserved Word.

Linq ;0)>