J juniorc New member Local time Yesterday, 20:08 Joined Aug 25, 2011 Messages 9 Sep 29, 2011 #1 Can I format a Combo Box to look like a Text box on a form i.e without drop down buttons for selecting lookup values.
Can I format a Combo Box to look like a Text box on a form i.e without drop down buttons for selecting lookup values.
V vbaInet AWF VIP Local time Today, 01:08 Joined Jan 22, 2010 Messages 26,374 Sep 29, 2011 #2 Hide the combo box and set the Control Source of the textbox to the Column of the combo box: Code: =ListboxName.Column([COLOR=red]x[/COLOR]) where x is the column number, i.e. 0 for the first column, 1 for the second column... and so on.
Hide the combo box and set the Control Source of the textbox to the Column of the combo box: Code: =ListboxName.Column([COLOR=red]x[/COLOR]) where x is the column number, i.e. 0 for the first column, 1 for the second column... and so on.
T teiben Registered User. Local time Today, 01:08 Joined Jun 20, 2002 Messages 462 Oct 24, 2011 #3 I've always place a small rectangle box over the arrow part and made it Transparent
V vbaInet AWF VIP Local time Today, 01:08 Joined Jan 22, 2010 Messages 26,374 Oct 24, 2011 #4 teiben said: I've always place a small rectangle box over the arrow part and made it Transparent Click to expand... Yep, it's a nice idea but if my cursor is in the Combo box and I use these key combinations, Alt + Down arrow key, the box will drop-down.
teiben said: I've always place a small rectangle box over the arrow part and made it Transparent Click to expand... Yep, it's a nice idea but if my cursor is in the Combo box and I use these key combinations, Alt + Down arrow key, the box will drop-down.
