is there anyway to programatically in VBA code convert a textbox to a combobox (set it's control source) and then later convert it back to a text box?
Much appreciated.
Salzan
I'm pretty sure the appropriate Commands to do the conversion would be:
- Application.RunCommand acCmdChangeToComboBox
-
Application.RunCommand acCmdChangeToTextBox
The problem as far as I understand it would be that the Form containing the Control must be in Design View, and you would need some Method that would shift focus to the Control before the Commands are applied. Just for curiosity, why would you want to do this? Wouldn't it be simpler to overlay the Controls, then manipulate them in this manner?