Input Mask for Date and Time

[Guest]

I have used the following input mask and format in a date/time field of a table

Format - "dd/mm/yy hh:nn"
Input Mask - 00/00/00\ 00:00;0;_

After I enter data into the field with this input mask (data is successfully
typed into the mask), and I press the enter key I get the following error
message:

"The vaule you entered isn't valid for this field
For example you may have entered text in a numeric field ora number that is
larger than the FieldSize setting permits"

Can someone explain this to me and what is the correct input mask to enter a
date and time into a date/time field?

Thanks
Dennis

 

[Arvin Meyer [MVP]]

I've always used:

99/99/00\ 99:00\ >LL;0;_

which allows entry like:

10/26/2006 7:30:00 AM

Notice the mm/dd/yyyy format. This is because of the Windows regional
settings in the control panel.

 

[Guest]

Hi Arvin,

Yes this worked ... Thanks

Dennis

I've always used:

99/99/00\ 99:00\ >LL;0;_

which allows entry like:

10/26/2006 7:30:00 AM

Notice the mm/dd/yyyy format. This is because of the Windows regional
settings in the control panel.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com