Changing a Text Box Control to a Combo Box Control

[L.A. Lawyer]

I want to be able to change a text box to a combo box (and back). How do I
do that?

 

[NevilleT]

I am not sure why you are doing it, but you might create both, and use the
visible true or false to decide which is displayed. You can put one over the
other. If you had a button you could use the following for the on click event

if btnChange.Caption = "Combo" then
cmbInput.Visible = True
txtInput.Visible = False
btnChange.Caption = "TextBox"
else
cmbInput.Visible = False
txtInput.Visible = True
btnChange.Caption = "Combo"
End If

Neville Turbit
www.projectperfect.com.au

 

[Tom van Stiphout]

On Thu, 8 Oct 2009 17:47:29 -0700, "L.A. Lawyer"

Simplest solution is to have two controls on top of each other, one
visible and one hidden.

-Tom.
Microsoft Access MVP