expressions in report giving #ERROR message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am try to design a report with fields containing the expression =LTrim("Text: "&[field_from_a_query]). What I want the field to do is display some text with the data from the query next to it (e.g. rather than show just the value 4/14/04, have it display "Date: 4/14/04"). Whenever I enter this expression into a field in the report, however, it displays the error message "#ERROR". I have tried to reverse engineer a solution by looking at reports that successfully use the expression, but why it is not working in my report escapes me. Does anyone know what may be causing this? How can I fix it? What am I missing?
 
Check to make sure the name of your control is not the name of a field. I'm
not sure why you would use LTrim() when your left-most text doesn't include
any spaces on the left.

--
Duane Hookom
MS Access MVP
--

benb said:
I am try to design a report with fields containing the expression
Click to expand...
=LTrim("Text: "&[field_from_a_query]). What I want the field to do is
display some text with the data from the query next to it (e.g. rather than
show just the value 4/14/04, have it display "Date: 4/14/04"). Whenever I
enter this expression into a field in the report, however, it displays the
error message "#ERROR". I have tried to reverse engineer a solution by
looking at reports that successfully use the expression, but why it is not
working in my report escapes me. Does anyone know what may be causing this?
How can I fix it? What am I missing?
 
Back
Top