How to set up input mask for an international date - dd/mm/yyyy?

G

Guest

I want to enter dates in a form using the format dd/mm/yyyy. I need the
input format to also use this format to mimick teh case report forms the data
is being entered from.
Thanks for your help!!!!
 
G

Guest

To enter the date in that format
Put in the field properties
Format Property = dd/mm/yyyy
InputMask Property = 99/99/0000

that will force the user to enter the date in that format with four digit in
the year.
 
J

Joan Wild

So if I enter 05/03/2005 is that May 3, 2005 or March 5, 2005; and how does
Access tell the difference?

You need to understand how Access interprets dates - it will use the short
date format as set in the Regional Settings of Control Panel. And that may
be different on different computers. Although you could change everyone's
computer, you really shouldn't change their preferences.

For a date, you are better off not having an input mask as it just slows
down data entry. You can enter mm/dd or dd/mm (depending on your computer
settings) and Access will assume the current year.

You should set a format that is unambiguous, so that the user can tell
immediately how Access interpreted their entry.

dd/mmm/yyyy is suggested

More information on dealing with dates at
http://www.allenbrowne.com/ser-36.html
 

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

Top