can controltype be changed at runtime?

[jesper f]

I have a db with a generic form displaying different
datasets. I'd like to be able to change the controltype
from textbox to combobox and back depending on what data
are displayed. It seems this can't be done except in form
design is this correct?
Thanks for your help.

 

[Ken Snell]

Just put both controls on the form, and make one visible while the other is
invisible. Changing a control from one thing to another is an unnecessary
overhead and will eventually reach the "max" limit of form changes for
controls, and then you won't be able to do it at all.

 

[Guest]

Just put both controls on the form, and make one visible
while the other is

invisible. Changing a control from one thing to another is an unnecessary
overhead and will eventually reach the "max" limit of form changes for
controls, and then you won't be able to do it at all.

Ok Ken, thanks.

 

[Jesper F]

eventually reach the "max" limit of form changes for

controls, and then you won't be able to do it at all.

Thanks again. What is the max number of form changes by
the way?
Is there a link that you know of with an overview of these
more or less known limitations of Access?

 

[Ken Snell]

754 controls over life of form.

Open Help from database window, and type Specification in the Index window.