Combo Box Properties

[Guest]

Is there any way I can change a combo box properties depending on what I
select in an option group? For example, if I choose the option 1, then I want
the combo box to have 3 columns, 1st column of width=0.5, 2nd column of width
=1", 3rd column of width = 1" and listwidth = 2.5". If I choose option 2,
then the combo box will have only 1 column with width of 0.5". Is that
possible to do using code? Thanks.
ck

 

[Larry Linson]

I think you can change all these properties at runtime. Remember that you
may need to change the Row Source if you are changing the number of columns.
The form containing the combo box will have to be open. They will only apply
for the open instance of the form; if you want the changes to be permanent,
you'll have to open the form in design view and change them.

Larry Linson
Microsoft Access MVP