If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 date picker property
In Access 2007, I have the "show date picker" property set to "for dates" for
a date field in a form based on a table. The date picker does not show up when I use the field. |
#2
|
|||
|
|||
Access 2007 date picker property
Remove anything in the Input Mask and Format properties of the control.
If that doesn't fix it, Access does not recoginse the control as bound to a date/time field. If it is an unbound control, try setting Format to General Date. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Dfrensley" wrote in message ... In Access 2007, I have the "show date picker" property set to "for dates" for a date field in a form based on a table. The date picker does not show up when I use the field. |
#3
|
|||
|
|||
Access 2007 date picker property
Thanks Allen - the field had an input mask carried forward from the table
that contains it. When I removed the mask, the date picker magically appeared. Thanks very much for your help. "Allen Browne" wrote: Remove anything in the Input Mask and Format properties of the control. If that doesn't fix it, Access does not recoginse the control as bound to a date/time field. If it is an unbound control, try setting Format to General Date. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Dfrensley" wrote in message ... In Access 2007, I have the "show date picker" property set to "for dates" for a date field in a form based on a table. The date picker does not show up when I use the field. |
Thread Tools | |
Display Modes | |
|
|