Autoexpand combo box for text that has been updated in vb....

[larry c via AccessMonster.com]

If I set a combo box's value in code, how can I force the box to autoexpand?
example:
1. mycombobox has a value of 644 in its list.
2. in code, I set
mycombobox = 6
now the combo box shows a value of 6, how do I get it to auto expand to show
644, and trigger the notinlist event if that applies?

thank you

Larry

 

[Wayne Morgan]

It won't do it from code, even if you use the combo box's Text property. You
would have to have to code search the values in the Row Source and pick the
closest one itself.

 

[larry c via AccessMonster.com]

Is using sendkeys to trigger the event BAD programming?

It won't do it from code, even if you use the combo box's Text property. You
would have to have to code search the values in the Row Source and pick the
closest one itself.

If I set a combo box's value in code, how can I force the box to
autoexpand?

[quoted text clipped - 9 lines]

Larry

 

[Wayne Morgan]

Send Keys has the potential to be problematic. The key strokes go to where
the focus is. If the focus should get shifted, it will cause you problems.
There may also be a workaround. See this link and the link it has for a
replacement for SendKeys.

http://www.mvps.org/access/bugs/bugs0004.htm

--
Wayne Morgan
MS Access MVP

Is using sendkeys to trigger the event BAD programming?

It won't do it from code, even if you use the combo box's Text property.
You
would have to have to code search the values in the Row Source and pick
the
closest one itself.

If I set a combo box's value in code, how can I force the box to
autoexpand?

[quoted text clipped - 9 lines]

Larry