Combo boxes / Lookup fields

  • Thread starter Thread starter Trevor
  • Start date Start date
T

Trevor

for some strange reason my combo boxes / lookup fields cease to work when
typing an entry I get "not an item on the list' when it's clearly there when
I scroll down using the mouse. I have posted this question before got a
response but the link gave me a blank page can anyone help
 
Trevor said:
for some strange reason my combo boxes / lookup fields cease to work when
typing an entry I get "not an item on the list' when it's clearly there
when
I scroll down using the mouse. I have posted this question before got a
response but the link gave me a blank page can anyone help
Click to expand...


One common cause of this is not changing the Allow AutoCorrect property of
combo boxes from its default value of Yes to No. (True and False if setting
the property in VBA). I saw a a good example of this just yesterday. Someone
was selecting from a combo box displaying names, and one of the names was
"Ballance". Because AutoCorrect had not been turned off, Access was
'helpfully' 'correcting' this to "Balance" and then complaining that the
item was not in the list.
 
Back
Top