turn combo box highlight off?

[MikeV06]

I have a main form with a subform. The main form has a combo box. The drop
down list is used to select an item which populates the subform. All works
as it should.

However, the selected entry in the combo box is highlighted (as it should
be since it was selected and in focus). What I would like to do is turn off
the highlight but leave the control in focus so that the drop down list can
again be used for selecting an item.

It that possible and if so, how?

Thank you.

Mike

 

[Rick Brandt]

I have a main form with a subform. The main form has a combo box. The
drop down list is used to select an item which populates the subform.
All works as it should.

However, the selected entry in the combo box is highlighted (as it
should be since it was selected and in focus). What I would like to
do is turn off the highlight but leave the control in focus so that
the drop down list can again be used for selecting an item.

It that possible and if so, how?

Manipulating the SelStart and/or SelLength properties of the ComboBox should
work for this, but for some reason when I test this they have no effect when
used in the AfterUpdate event of the ComboBox.

I was testing in Access 97 so if you have a different version you could
still try that as it might work in newer versions.

 

[MikeV06]

Manipulating the SelStart and/or SelLength properties of the ComboBox should
work for this, but for some reason when I test this they have no effect when
used in the AfterUpdate event of the ComboBox.

I was testing in Access 97 so if you have a different version you could
still try that as it might work in newer versions.

I am using 2003. It did not do anything for me either. After the update the
blinking cursor is located at the left most side of the combo box [two
columns, but column(0) is the only one visible until the drop down arrow is
selected] and it is highlighted (which normally means selected). If I click
on the rightmost side of the field the blinking cursor moves to the
rightmost side of the field and highlighting turns off.

I have tried changing the focus to another control and then back. However,
it appears that one cannot change focus to a label? How do I move the
blinking cursor to the end of the field which turns off the hightlight?

It should not be this hard...

Thank you for your suggestions.

Mike