Date input mask

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
 
K

Ki Yi [MS]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing a date entry format of dd/mm/yyyy 1
ceate date in form using input mask 9
Custom Date Format and Input Mask Trouble 5
europe date format / input mask 1
Access 2003 Date Input problem 3
Format Date "dd/mm/yyyy" 1
Entering and Viewing dates in a form 5
Date format automatically changed 1

Top