Concatenating in reports

[yhgtbfk]

I have a firstname field, and a surname field.

On a report I have a textbox that is bound to =[firstname] & " " & [surname]

This gives me an error. I have even tried single quotes, but no luck.

Please advise

Thank you in advance

 

[RuralGuy]

Concantenate the fields in the underlying query or bind the fields to invisible textboxes and concantenate from the textboxes rather than the fields.

 

[skvic]

Different name

What's the name of textbox? Maybe it is same as one of the fields that you want to oncantenate if you did copy paste? I did that least 100 time Just change the name to full name or something!