convert text box to combo box using vba

M

macroapa

Hi,

how can i change a textbox to a combobox using vba?

I want some users to have the field as a text box (disabled and
locked) and some to have it as a combox (enabled and unlocked).

Thanks.
 
B

Brendan Reynolds

macroapa said:
Hi,

how can i change a textbox to a combobox using vba?

I want some users to have the field as a text box (disabled and
locked) and some to have it as a combox (enabled and unlocked).

Thanks.
Click to expand...


You'd have to open the form in design view to do that. An easier solution,
that doesn't require the form to be in design view, is to have both a combo
box and a textbox on the form, and just set the Visible property to hide the
one you don't want the user to see.
 
Top