MM/YYYY Input format

[Charles P. \(Pat\) Upshaw]

How can I assure that entering a date in MM/YYYY format cannot be entered as
mm/dd/yyyy? My input form will accept the offending format, whereas my
queries will not.

Thanks,
Pat Upshaw

 

[NikkiNYCC]

You can change the input mask to 00/0000 which should allow you just a month
and year entry.

a) Go to your table and click on design
b) click on the field (data type should be Date/Time
c) on the 'General' tab below there should be an option 'Input Mask'
d) simply fill it out 00/0000

This should (I hope) Work for you

 

[rvanl]

Use the Input mask option for the edit box on the form:
Something like: 00/0000;0;# might do the trick.
Hmm I haven't tried something like 00//0000, but that may be
interesting as well.
R