Input mask for General Date data format

B

brandon

I am using Access 2000. I've defined fields as
Dte/Time, "General Date" format in a table. In an
associated form, I want the user to input date and time,
andi I thought an input mask would be the way to ensure
that this happens. There is no "canned" mask for this
format in the Input Mask Wizard. I have tried to create
my own, using instructions and examples in Access Help and
in 2 or 3 Access books. The mask guides data entry OK,
but when I try to move to the next field, I get an error
message saying that the data I have entered is
incompatible with the field definition. By the way, I
have tried the mask both on the form and in the table
design, neither works.
Any help would be appreciated.
 
B

brandon

Wayne,
Works great! Many thanks.
Brandon
-----Original Message-----
Will this work for you?

99/99/0000\ 99:00:00\ >LL;0;_

--
Wayne Morgan
Microsoft Access MVP





.
 

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