show combo box without dropdown arrow (1 Viewer)

sammers101

Registered User.
Local time
Today, 02:39
Joined
May 11, 2012
Messages
89
Is is possible to use a combo box but not show the drop down? I've disabled it so it isnt possible to change, but I would prefer it to appear like a regular text box. The combo box has two columns, ID and name, it auto selects the ID when loading and shows the user the name. Unless that's possible to do with a text box?
 

sneuberg

AWF VIP
Local time
Yesterday, 23:39
Joined
Oct 17, 2014
Messages
3,506
One way to make a text box do this is just make a DLookUp the control source of the text box. Since the combo box is current being set to the ID of the user then I assume it must be available. So the control source of the text box would be something like

=DLookUp("[UserName]", "[TheTableName]", "[ID] = & Me.ID")

I believe you could also do this with a subform. You can hide most of the stuff you normally see in a subform to the point where just a textbox appears.
 

Users who are viewing this thread

Top Bottom