One way that might work is to stack two controls on top of each other -
a combobox and a textbox.
-- Bind the two controls to the same control source.
-- Make the combobox narrower than the textbox
-- make sure the textbox is on top of the combobox. (Menu: Format: Move
to Front]
-- In the got focus event of the textbox, change the width of the
combobox to be wide enough to show the data and the "arrow"
-- Use Me.comboboxName.SetFocus to move the focus to the combobox.
-- In the lostFocus event of the combobox set the width of the combobox
control to shrink it so it will be hidden by the textbox.
-- OH, and set the tabstop property of the combobox to NO so you won't
tab into it. That will will be handled by tabbing into the related text
control.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================