Is it possible to change a control properties from within VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is my issue. I hav a Text Box in a form that is bound to a Table and
when I want to display a Field in a Record that is fine but I also want to
have the user select from a Combo Box in order to change or enter information
in that field. The way that I acieve that is to have a Combo Box superimposed
on a Text Box and hide the combo when I want to look at the text Box etc.
This works but seems rather cumbersom. Within Tools, I can change a Combo to
a Text box and I wondered if there was a way to do that from within VB. If
so, I would only need 1 Box in the Form.

Thanks RayC
 
What you're doing is probably the best approach.

I don't believe there's any way to do the same sort of conversion using VBA.
Even if there was, though, there's a limit as to how many controls can be on
a form during its lifetime. Each time you converted between text box and
combo box, you'd be incrementing the counter so that eventually the form
would stop working.
 
Somewhat related to the same issue, could you possibly help me with queries?
I have not delved into queries in any way whatsoever and I recntly tried to
follow some advice but nothing worked and I gave up. If someone could
possibly talk me through on very rudimentary level, I am sure that I would
pick it up and be able to move forwards from there.
If you can help you should serch the postings here for "RayC" and read
through my topic "there must be a better way" which explains mu current
problem. In trying to resolve it, I have Text Boxes Superimposed on Combo
Boxes.

I realy appreciate your Help
RayC
 
Back
Top