Concatenation In Detail Section of Report

[Lori]

I am trying to concatenate several fields (name, addr,
city, etc) in the detail section of a report using the
ampersand. I keep getting an error message that
states "Microsoft cannot find the field [field name1]&" "&
[field name2] referred to in your expression."

I can do this in the header section. Am I doing
something wrong?

 

[Duane Hookom]

Are you preceding your expression with "="?

 

[Guest]

I did try this but got the same error message.

-----Original Message-----
Are you preceding your expression with "="?

--
Duane Hookom
MS Access MVP

I am trying to concatenate several fields (name, addr,
city, etc) in the detail section of a report using the
ampersand. I keep getting an error message that
states "Microsoft cannot find the field [field name1] &" "&
[field name2] referred to in your expression."

I can do this in the header section. Am I doing
something wrong?

.

 

[Loretta Jean]

Would you post the expression exactly as you have it
entered along with the NAME of the textbox the expression
is located in?

Thanks