No MatchEntry property in Access combo boxes? (97/SR-2)

Topic

New Reply

This is another one of those seemingly simple, stupid questions.

Apparently, there’s no MatchEntry property in Access 97’s combo boxes like you have in regular VB/VBA combo boxes.

So how would you control the MatchEntry behavoir of the combo boxes in Access? What’s crazy is that some of my Access combo boxes are behaving like frmMatchEntryComplete while others are behaving like frmMatchEntryFirstLetter, and I don’t know why! (I want all the Access combo boxes to behave like frmMatchEntryComplete.)

Thanks,

Stephan

Reply | Quote

Replies

Not sure what a MatchEntry property is

But try looking up “Limit to List” and “Auto Expand” in help.

HTH

Reply | Quote

Thanks, it’s the AutoExpand property I want — this is analogous to the MatchEntry property in VB/VBA combo boxes. I love it when Microsoft doesn’t make things consistent.

Apparently, in my Access combo boxes which are exhibiting the aberrant AutoExpand behavoir, I have combo box Change event procedures, and when I rem’ed out the code, the AutoExpand behavoir of the combo boxes works fine — although NOTHING in my code altered the AutoExpand property! Looks like I found another Microsoft bug.

Thanks again for your reply,

Stephan

Reply | Quote

Access drop-down combo boxes are quite different from their cousins in VB. In general you don’t want code running on the OnChange event – you want it to run on the AfterUpdate or NotInList events. It’s actually one of the strongest features of Access, and has been virtually bug free in all of the releases.

Reply | Quote

You forgot to mention that you don’t have to move mountains to populate the lists in Access comboboxes, either. Just set the RowSource to the table or query name or a SQL Select statement and voila!

Reply | Quote

Good point! We hardly ever work in VB because there is so much more work involved. We used to do it occasionally when we really needed real-time performance, but with the ADPs we can pretty well match VB performance in Access 2000/XP.

Reply | Quote