Date Picker Issue

mkdrep

Registered User.
Local time
Today, 18:45
Joined
Feb 6, 2014
Messages
181
I am using Access 2007 and I have had a curious issue arise.

I like to use the Date Picker feature on all my forms to make it easier to enter dates. I have set up each table's date field property to "show date picker for dates", as per attached (.jpg)

When I use that particular field in a form, I also set up the field to allow for the Date Picker option (date picker form property sheet.jpg)

The curious part is that not every form that I set up actually shows the date picker when I select the date field. Some forms it works perfectly, others it doesn't. :confused:

Any suggestions as to why this might be? Thank you in advance....
 

Attachments

  • Date Field in Table-Property Sheet.jpg
    Date Field in Table-Property Sheet.jpg
    24.9 KB · Views: 105
  • Date Picker Form Property Sheet.jpg
    Date Picker Form Property Sheet.jpg
    14.3 KB · Views: 109
you need to set each date control format property to a date format and I seem to recall you should not use an input mask (but may be wrong on that)
 
you need to set each date control format property to a date format and I seem to recall you should not use an input mask (but may be wrong on that)

Deleting the input mask did the trick! Thank you very much1
 

Users who are viewing this thread

Back
Top Bottom