Unhighlight selected text in access 2003 combobox

johnnyg123 used Ask the Experts™
Is it possible to unhiglight the entry (through vba) that appears in the textbox portion of a combobox after an item is selected?  (I know it is possible to click in the box to remove it but just trying to save the user a click)

Perhaps changing the color used to highlight?

I understand that each entry is highlighted as the mouse moves over it as a visual cue but it is rather annoying to have the entry displayed in the "textbox" portion highlighted after the item has been selected.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Try this:

Me.YourCombo.SelStart = 0
Me.YourCombo.SelLength = 0


I tried in the on changed event for the combo box but no luck

Perhaps I should try somewhere else?
Top Expert 2006

it should work on the change event, I gave it a test for another event and it didnt work - this for the afterupdate event. so tested change event and it worked.

place a msgbox in your change event

msgbox "Hello"

so if it comes up then you know if the event has kicked in or not

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial