Combo box date format problem

[Silvio]

I have a combo box as follow:

Format: Short Date
Limit to List: Yes

The problem I am having is that when users type a date in a format like
1/5/09 …the combo box will reject such entry since it does not match the date
format in the combo box list; in the example used above the combo box format
is: 01/05/2009

How can I handle this problem and allow users to enter valid dates
(available in the combo box list) in whatever format they choose?


Thanks you folks.

 

[Jeff Boyce]

Usually (in my experience), Access doesn't reject data entry because the
value doesn't match the "format". Usually a rejection is due to a mis-match
with an Input Mask. Does this field have an Input Mask?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Silvio]

Jeff, I do not use an input mask (so people can enter dates in whichever
format they want). I was under the same impression as far the format goes...
but I am wrong. I think the "Limited to the List" forces the format matching
(???).

 

[Silvio]

Jeff, it makes any difference, the combo box uses "Group By" in order to
generate unique dates list.

 

[Jeff Boyce]

Silvio

If it isn't related to an Input Mask, I'm afraid I'm fresh out of ideas.
Perhaps one of the other newsgroup readers has run across this.

(?Have you tried removing the LimitToList constraint -- for testing purposes
only?)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Silvio]

Jeff, by removing "Limit to list" then it works fine (the entry will reformat
it self as 01/05/2009). However, for obvious reasons, I would like limit the
entry to the list. Probably a “lost focus†action could re-format the entry
to "Short Date" but I don't know how... :-(

I am using this combo box to search for specific records therefore I will
loose focus in order to click on my “Search†button.