Change a text box to a combo box, acCmdChangeToComboBox

[h3lm3t]

Hi there, i having trouble changing a text box control to a combo box, i looked at MSDN but could not find the correct sysntax, or even any refernece to the function.

Its part of doCmd.RunCommand

Any ideas n how to change it ?
Thanx in advance for any and all help
cheers
h3lm3t

 

[BillPower]

Hi h3lm3t,

This site demonstrates better than I could on how to use acCmdChangeToComboBox and other related constants:

http://home.clara.net/tkwickenden/codeex/227to234.htm

Before you start delving into this or possibly wasting your time, you would only be able to use this Function while in design view of a form or report.

Bill

 

[h3lm3t]

Hi Bill, thanx for the reply, i had been to that site, i ended up doing a workaround.
I messed around and got this

close form
open form in design
Me.txtManuName.ControlType = acComboBox
close form ( over-ride the save)
open form

that worked, just incase anyone wants to know.

Again ta for the help Bill.
regards
h3lm3t