Using query fields in an expression

S

Sam Hobbs

My report is based on a query. When I have a textbox with a source of a
field then the data is shown without error. When I change the source to
"=Trim([Source])" I get an error for the field in the report. When I add
another textbox that is hidden and such for the field then the expression
works. It is very frustrating; I tried it several times using a few
different fields. It consistently works with the additional textbox and does
not work without it.
 
A

Alphonse Giambrone

It sounds like the name of the text box is the same as the source.
Just change the name of the text box.
 
S

Sam Hobbs

Thank you.

I have not logged into the system to try it, but I am confident you are
right. I looked at the Northwind "Customer Labels" sample previously and did
not notice that the name of the text box is different from the source.



Alphonse Giambrone said:
It sounds like the name of the text box is the same as the source.
Just change the name of the text box.

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us


Sam Hobbs said:
My report is based on a query. When I have a textbox with a source of a
field then the data is shown without error. When I change the source to
"=Trim([Source])" I get an error for the field in the report. When I add
another textbox that is hidden and such for the field then the expression
works. It is very frustrating; I tried it several times using a few
different fields. It consistently works with the additional textbox and does
not work without it.
Click to expand...
Click to expand...
 
Top