MM/YYYY Input format

  • Thread starter Charles P. \(Pat\) Upshaw
  • Start date

C

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
 
Ad

Advertisements

N

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
 
Ad

Advertisements

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top