Does anybody know the input mask in MS Access for Month and year?

Question

Hi,
Im just designing a table and want the input mask to be full name of month and then full year for example:
"October 2006"

Thanks in advance!!

Answer 1

I agree with those here, use a drop down if you need that exact text, or have the user enter "10/2006" and programmatically (that means you have to write a little bit of VBA) to enforce strict adherence to this format. I believe there is some syntax where you can specify "LIKE [0-9][0-9]/[0-9][0-9][0-9][0-9]". Can't think of it at the moment though. I think it depends on if you're having them input directly into the table or in a form.

Answer 2

I don't think anyone read your question fully. Why are you trying to put an input mask in the TABLE itself?
Usually the FORMAT wil be set at the table level (I.E. Short Date" or "General DATE"), and the input mask on the INPUT FORM.
The Mask is to control how the data is viewed on different forms (so it could be the Short date of 10/3/2006 on one form, but only show "October 2006" on another).
The forms have an INPUT MASK WIZARD just for that sort of thing.

Answer 3

The easiest (and really the only, if the field is a date field) way to do this is not to use an input mask, but rather to control the way the data is displayed.

That is, have the user enter, 10/1/06 in the field, and have it then display, "October 2006".

To do this, change the format property of the field (in table design view and in any existing forms and reports) to "mmmm yy" (without the quotes).

Answer 4

Tricky one, it might be better just to edit the field on the form to that format ?
Months have different numbers of letters, so a standardised input mask would be awkward to do.

Answer 5

it would be easiest to create a drop down box of months to create the month field and have the year field seperate

Answer 6

try ......... month([OrderDate]) = Month(Now()) And Year([OrderDate]) = Year(Now()).....
you could also just use the///// = month (now()) and = year (Now())