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?