Getting #Error

G

guest

Hi

I have a textbox with the control source to: = IDNo & " " & IDName .
When I preview the report, I would get "#Error" instead of "1 Apple"
for example.

I would work if I have a textbox for each variable.

Anybody know why it doesn't work?

Thanks
 
F

Fons Ponsioen

I suspect that the textbox is named the same as one of
your variables.
Change the name of the textbox, after you do that, make
sure that the = IDNo & " " & IDName was not automatically
updated also.
Hope this helps.
FOns
 
G

guest

Thank you Fons!!

That was the problem. The textbox has the same name as the record
field.

Damn, you are good!!!
 
F

Fons Ponsioen

I have done that a few times myself.
Take care.
-----Original Message-----
Thank you Fons!!

That was the problem. The textbox has the same name as the record
field.

Damn, you are good!!!




.
Click to expand...
 
Top