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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing combo box box that's not an option in its drop-down list 5
Combo Box Update 22
Setting a combo box value 8
Combo Box Requering 2
Combo box selection 5
combo box 3
convert text box to combo box 2
Access Combo Box controls for current record only 1

Top