combo box won't auto-type auto-fill in, why??

T

tlyczko

I've been working on an Access form(s), and their combo boxes stopped
having the behavior of 'auto-filling' themselves when the end user
starts typing a correct value.

What happens now is even if the user types in the beginning of a
correct value, Access just says it's not a valid value, drops down the
list, and more or less makes the user use his/her mouse to select the
correct value.

How do I re-enable this?? I know it's probably something simple that I
can't think of or find.

Thank you,
:) tom
 
F

fredg

I've been working on an Access form(s), and their combo boxes stopped
having the behavior of 'auto-filling' themselves when the end user
starts typing a correct value.

What happens now is even if the user types in the beginning of a
correct value, Access just says it's not a valid value, drops down the
list, and more or less makes the user use his/her mouse to select the
correct value.

How do I re-enable this?? I know it's probably something simple that I
can't think of or find.

Thank you,
:) tom

Set the combo box's AutoExpand property to Yes.
It's on the Data tab.
 
T

tlyczko

Hello Fred,
Thank you for your suggestion.
I tried this, and it didn't work.
I have to have Limit to List turned on.
I haven't figured out what the problem is...
Thank you,
Tom
 
T

tlyczko

I got lucky on Google and found this MSKB article:
"The AutoExpand property may not work when ANSI-92 syntax is enabled
and the Combo Box RowSource does not use DISTINCT values"
http://support.microsoft.com/default.aspx?scid=kb;EN-US;824189
I don't have ANSI-92 enabled but adding DISTINCT to the SQL of the
little lookup query made it work normally.
Who knows why it worked???
Thank you,
:) Tom
 

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