Date input mask

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I would like to create a input mask to enter the date in a column

I believe my mask should look something like :"99/99/0000;0;_" but my question is: is there a way to display to the user something along the lines of mm/dd/yyyy instead of __/__/___

if I use this mask it is possible to enter either mm/dd/yyyy or dd/mm/yyyy and may cause data errors

Thank

Daniel
 
Hello,

You can create a form based on a table and then put a message
box in OnEnter event -- ie. MsgBox "please enter date in mm/dd/yyyy format"


Regards,

Ki Yi
Microsoft Support

This posting is provided AS IS with no warranties, and confers no rights.
 
Back
Top