Getting #Error

  • Thread starter Thread starter guest
  • Start date Start date
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
 
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
 
Thank you Fons!!

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

Damn, you are good!!!
 
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...
 
Back
Top