txtbox 2 combobox using vba

[x taol]

i want to change textbox to combobox type using vba.
*** Sent via Developersdex http://www.developersdex.com ***

[storrboy]

On Feb 17, 12:43 am, x taol <[e-mail]:

i want to change textbox to combobox type using vba.

*** Sent via Developersdexhttp://www.developersdex.com***

Ok.
What's the question?

[x taol]

i want to change control type of form.
namely, textbox to combobox using vba code.

*** Sent via Developersdex http://www.developersdex.com ***

[storrboy]

On Feb 17, 7:19 pm, x taol <[e-mail]:

i want to change control type of form.
namely, textbox to combobox using vba code.

*** Sent via Developersdexhttp://www.developersdex.com***

Since you clarified your original post I'll assume you are asking how.

DoCmd.OpenForm "FormName", acDesign
Forms("FormName").TextBoxName.ControlType=acComboB ox
DoCmd.Close acForm, FormName, acSaveYes

[x taol]

thank you, storrboy
oh, i want to change the control in not form but table.
i'm sorry.

*** Sent via Developersdex http://www.developersdex.com ***

[storrboy]

On Feb 17, 9:37 pm, x taol <[e-mail]:

thank you, storrboy
oh, i want to change the control in not form but table.
i'm sorry.

*** Sent via Developersdexhttp://www.developersdex.com***

Why would you want to do this?
It really is bad practise to allow user to edit the tables directly -
always use forms to do this.
Either way, changing the control type is only possible when opening
the container object in design view.
I can't think of why you would do this to a field during runtime. Make
the changes to the table field and leave it that way.

[Larry Linson]

"x taol" <to******@yahoo.comwrote in message
news:45*********************@news.qwest.net...

thank you, storrboy
oh, i want to change the control in not form but table.
i'm sorry.

On occasion, The Boys and Girls in Redmond have some Very Bad Ideas. One of
the worst of their Very Bad Ideas was "Lookup Fields in Tables" which I
presume is what you mean by "Control in Table". I assure you that you will
indeed "be sorry" if you make the Field in the Table into a Lookup Field --
in time, that will come back to haunt you and make your life more
complicatated and traumatic than you would like.

Larry Linson
Microsoft Access MVP