Input mask for General Date

[Guest]

Trying to create an input mask for a form where the table field is using
General Date ie. 01/01/2005 8:00:00
I have tried to create a mask but no matter what I try I get a message when
entering the data that the value entered is not valid for the field. Any
help would be appreciated.

Thanks,

Jeff

 

[John Vinson]

Trying to create an input mask for a form where the table field is using
General Date ie. 01/01/2005 8:00:00
I have tried to create a mask but no matter what I try I get a message when
entering the data that the value entered is not valid for the field. Any
help would be appreciated.

Thanks,

Jeff

Access will interpret dates pretty reliably without any mask, and I
find that masks often do more harm than good; but if you insist, a
mask such as

00/00/0000\ 00:00:00

will work. It will require the user to type all fourteen digits
however (leave the seconds as 99 if you want time to the minute).

John W. Vinson[MVP]

 

[Guest]

hmm, that mask you suggested is exactly what I did and get the error message
"value entered is not valid for the field". The table field format is set to
General Date, and the form field format is set to the same? It works fine
without the mask, so I am not sure what the problem is. I agree with you on
the masks, but in this case where we have 50 users I hope to eliminate some
questions. Let me know if you have any other ideas. As always I appreciate
your help.

Regards,

Jeff

 

[John Vinson]

hmm, that mask you suggested is exactly what I did and get the error message
"value entered is not valid for the field". The table field format is set to
General Date, and the form field format is set to the same? It works fine
without the mask, so I am not sure what the problem is. I agree with you on
the masks, but in this case where we have 50 users I hope to eliminate some
questions. Let me know if you have any other ideas. As always I appreciate
your help.

hm. You probably need the trailing semicolons; and to save the users
having to type two extra digits if you don't need time to the second,
you could leave off the seconds:

00/00/0000\ 00:00;;


John W. Vinson[MVP]