Forcing date format

[JaB]

Hi

Im using the date format dd/mm/yy hh:mm in a field in my table and users
will input this information via a form.

Other than actually making a note on the form to advise how to input the
date, is there any markers I can put in access to advise how this data needs
to be entered. I was looking at input masks or validation but not sure
either really does what Im looking for.

Thanks

 

[Allen Browne]

The way Access interprets the date depends on the date settings on the
user's machine.

I work in a dmy country like you, but if I create a database and send it to
someone in the US, Access will ask Windows for their date settings and
interpret the date according to their settings. There is nothing you have to
do to achieve this: MS has done it for you.

There is something you have to do if you create SQL strings, or use criteria
for DLookup() etc, or put literal dates in VBA code. For details, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

I suggest you don't use input masks. All they do is slow down a good data
entry operator. If you want to use Formats, use one of the built-in named
ones such as Short Date or General Date.

 

[KARL DEWEY]

The text box on your form has a property called Control Tip Text where you
enter information that is display when the mouse moves over the text box.
Use this property to tell operators what and how to enter data.