I finally found some confirmation on the MS site that if you use an Input
Mask, the date picker will not work:
http://office.microsoft.com/en-us/access/HA100964521033.aspx
<<Note If you use an input mask for a Date/Time field, the Date Picker
control is unavailable for use with that field.>>>
I can probably do a work around where I show a custom button that then
pops
the calendar for a hidden text box or something, then set that value into
the
real date text box... blah, blah, blah.... Not sure if it's worth it...
If anyone knows WHY the date picker control won't display because of an
Input Mask being specified, I'd love to know that one....
Thanks
"tommg" wrote:
> Using Access 2007. I have a text box with the following properties set
as
> such:
>
> Format = Short Date
> Show Date Picker = For Dates
> Default Value = Date()
> Input Mask = 99/99/0000
>
> Using the properties specified above, I simply do NOT get the date
picker
> displayed. The inputmask works as expected though.
>
> If I remove the 'Input Mask', then the date picker will display as
expected.
>
> I tried showing the date picker through code on the GotFocus() event of
the
> control (DoCmd.RunCommand acCmdShowDatePicker), but received the
following
> error:
>
> Runtime Error 2046. The command or action 'ShowDatePicker' isn't
available
> now.
>
> Any ideas on how to be able to use both the Date Picker AND the Input
Mask
> on the same control?
>
> Oh, and I tried it on a bound or unbound control and received the same
> results.
>
> Any help appreciated!
> Thanks!
|
