Combining Fields Into Single Text Box

[MaxQTime]

I have a database with names and addresses and I am having some trouble combining some into single text boxes on the report to make it look a little nicer. For example FisrtName and LastName or City and Province. I have set the text to =[FirstName] & " " & [LastName] and I'm getting a #Type! error when I run the report. Same thing for the City and Province.



The First Name and Last Name I have on one of the forms combined into a single text box and it is working fine there. I have tried googling for the answer to this and can't seem to find anything either.

Is this possible in reports?

[June7]

This expression works for me.

Do your field names have spaces? You show them with and without space.

Try doing concatenation calc in query and binding textbox to that field.

[Bob Fitz]

In the reports underlying query create a calculated field with FullName:[NameOfFirstNameField] & " " & [NameOfLastNameField]

Create a control in the report and set its Control Source property to FullName

[MaxQTime]

Thanks, moving that to the query makes so much sense.

[Micron]

Your controls and fields don't have the same names by any chance?

[MaxQTime]

They probably do actually

[Micron]

In retrospect, it probably shouldn't matter in a case like this. June7 might have the right idea but you didn't comment on the question about name variations. Another guess is that the calculated textbox is on a sub report, or the referenced fields are. I suspect you've already discovered that putting the concatenation in the query solves it.