Using query fields in an expression

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

 

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

 

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

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

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.