dim as control (Access 97)

Topic

New Reply

i was just wondering if there was a way to dim a string value, such as “Forms!Form1.Text1” as a control to reference later to enter a value? I can provide more information if needed, but i would just like this simple question answered. thanks in advance

Reply | Quote

Replies

It isn’t clear what you want to do. You can declare an object variable as a control, but the way you set it will depend on where you’re setting the object variable. In any event, you would need the name of the control and the name of its parent form as separate strings so that you could later say:

Set objCtl = forms(strFormName)!(strControlName)

Reply | Quote

thanks a bunch charlotte! it worked fine!

however, i had to remove the “!” from the statement because it was giving me some kind of error. the statement
Set objCtl = forms(strFormName)(strControlName) worked perfectly.

thanks again

Reply | Quote

Sorry about that, it’s one of the problems with air code. The syntax is analogous to DBEngine(0)(0) referring to the default workspace and current database. You need punctuation only if you reference the specific collections by name (i.e., DBEngine.Workspace(0)).

Reply | Quote

wow!
again i am awed by the amount of knowledge you have in that brain of yours. i will pretend that i know exactly what you are talking about after your smiley ). you have helped me several times in the past and i would like to thank you once again for gettimg me out of a tight spot )

Reply | Quote