Combo box date format problem


S

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.
 
Ad

Advertisements

J

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
 
S

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
(???).
 
S

Silvio

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

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
 
Ad

Advertisements

S

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.
 
Ad

Advertisements


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