View Single Post
  #1  
Old April 12th, 2010, 07:25 PM posted to microsoft.public.access.forms
cloclo via AccessMonster.com
external usenet poster
 
Posts: 3
Default date+time input mask

Hi,
I have a textbox where I'd like users to input date and time in the format:
mm/dd/yyyy hh:mm AM (or PM).

My input mask is: 00/00/0000\ 00:00\ LL

The format is General Date.

The column this textbox is bound to on the table is date/time with format of
General Date.

When I input a date and time, I'm getting an error. I input 03/31/2010 01:
15 AM. When I tab off the field, I get the following message: "The value you
entered isn't valid for this field".

What am I doing wrong?

thanks.
CLO

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1