Not in list - Dates

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?
 
G

Guest

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
 

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

Similar Threads

Combo box date format problem 5
diff colors for diff values in combobox 6
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Need to use F9 to requery in subform 7
Adding records relating to intervals between two dates 4
Not In List question 1
Value pushed to textbox doesn't invoke LimittoList 3
Formatting combo box drop-down list 1

Top