Using query fields in an expression

  • Thread starter Thread starter Sam Hobbs
  • Start date Start date
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.
 
It sounds like the name of the text box is the same as the source.
Just change the name of the text box.
 
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...
 
Back
Top