Unbound text boxes no longer display data! 2003

W

WRG!

I just upgraded to Access 2003. Everything pretty well works on my primary application. However, on every form and every report, unbound text boxes whose controlsource is equated to a declared variable in the class module now display only the error indicator #NAME? or #ERROR.

Even a new database created in Access 2003 does this. e.g the following code:

Class module has the following declaration.
Public TsT as String

MyForm_Load subroutine has the following code
TsT = "This is a Test"

Form has unbound text box named txtTest.
The controlsource is set as follows: =[TsT]

When the form is executed, the control txtTest displays #NAME?

If I convert txtTest into a lable I can do the following:
 
W

WRG!

Sorry, premature send..... :>) Finished below...

WRG! said:
I just upgraded to Access 2003. Everything pretty well works on my primary application. However, on every form and every report, unbound text boxes whose controlsource is equated to a declared variable in the class module now display only the error indicator #NAME? or #ERROR.

Even a new database created in Access 2003 does this. e.g the following code:

Class module has the following declaration.
Public TsT as String

MyForm_Load subroutine has the following code
TsT = "This is a Test"

Form has unbound text box named txtTest.
The controlsource is set as follows: =[TsT]

When the form is executed, the control txtTest displays #NAME?

If I convert txtTest into a lable I can do the following:
txtTest.Caption = "This is a Test"

This properly displays "This is a Test" in the control.

This seems to be some kind of global problem. I plan to reinstall but I wonder if there is an installation setting that I need to pay attention to, or what ????

Any help will be appreciated. This is a very basic kind of procedure for Access!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top