Getting #Error

[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

 

[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

 

[guest]

Thank you Fons!!

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

Damn, you are good!!!

 

[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!!!




.