Not in list - Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that shows a listing of training dates. The combo box
looks up values in a table.

I have the limit to list prop set to Yes and have code attached to the
NotInList event, however I'm having a problem.

If the user enters 5/2/07, instead of 5/2/2007, the date doesn't get
'recognized' as being in the list. I know that I can change the format of
the date to m/d/yy in the table to have it be recognized, but then if someone
enters 5/2/2007 that won't be recognized.

Is there any way for me to re-format the date that is entered before the Not
In List runs?
 
You can set the InputMask property of the combo, so that use will have to
enter a date with four years digits,

00/00/0000

With two digits years if the user enter 01/01/30 Access will recognize it as
01/01/1930

Under 30 it will be 2000+ Above 30 it will be 1930+, so it's better forcing
the user type 4 digits year
 
Back
Top