Combobox How to? Use one field, Display Another

[croy]

For a certain combobox control on a crowded data-entry form,
it would be handy if the clerk could type in a number
(special, data-entry code), but upon leaving the cbo, have
it display the text from another field (special, short text
code).

The benefit would be to make the data-entry form a
"numeric-keypad-only" form (for speed), but give the clerk a
quick way of asserting, if in doubt, that the entry was
correct. There are about 25 possible entries, and the
clerks get to know codes pretty quickly. They would rather
remember a number, than take their hand away from the
numeric keypad. But they would also like to see the text
code afterward, and there's just not enough room on this
form to show both.

Is there a way?

 

[John W. Vinson]

For a certain combobox control on a crowded data-entry form,
it would be handy if the clerk could type in a number
(special, data-entry code), but upon leaving the cbo, have
it display the text from another field (special, short text
code).

The benefit would be to make the data-entry form a
"numeric-keypad-only" form (for speed), but give the clerk a
quick way of asserting, if in doubt, that the entry was
correct. There are about 25 possible entries, and the
clerks get to know codes pretty quickly. They would rather
remember a number, than take their hand away from the
numeric keypad. But they would also like to see the text
code afterward, and there's just not enough room on this
form to show both.

Is there a way?

One way is to have a textbox superimposed on the text area of the combo box.
Set its properties to:

Control Source:
=comboboxname.Column(n)

to display the desired text field; note that the Column() property is zero
based

Tab Stop: No
Enabled: No
Locked: Yes

The combo box will "jump" in front of the textbox when the user tabs into it.