Simple Input mask question

[homer2002]

Hi all

this should be simple, but i'm having a brain attack!

I need an input mask on a form that restricts the user
so only the 1st day of each month can be entered as a value

i.e

01/05/03 or
01/11/04 ..... you get the idea


I tried
"01"/00/00


Guess what.. it didnt work :-D

 

[namliam]

i dont think it can be done with an input mask. You will need to enforce it with a validation rule...

Regards

 

[ghudson]

Sure you can. Put this as the input mask for your field and you will only be able to key in the two digits for the day of the month. The month is fixed as 01 and the year is fixed as 2003.

"01/"00"/2003";0;#

You will have to use VBA in the OnCurrent event to change the input mask if the month and year will change based on certain conditions.

HTH