Putting values from a variable into a text box on a Report

[Brettrb]

I am working in Microsoft Access and I have been trying to create a report in which the values in the text boxes changed based on an earlier form my users filled out.

My script:
TextBox1 = Value1
TextBox2 = Value2

It gives me an error saying value cannnot be set for this type.

Also I will need to eventually create strings in the script with the locations of fields in my query. So I will need to be able to set the text box equal to the variable holding my string.

Any suggestions on how to fix this problem?

Thanks

Brett Beckett
[email protected]

[BHostmeyer]

You would have better luck doing it like this.

text1.text = val(value) this returns the value of the string and not the string. You wont haft to worry about the data type.

Hope this helps.

Brooke Hostmeyer
Vijon Labs Inc.