Concatenation

[Rjc8513]

I'm stumped.

Trying to combine the text "City" with the field value [CITY] in a text box on a report. Have tried many different combinations but can't get it to work.

"City: " & [CITY]

Any suggestions? Thanks.

 

[ideafixer]

Is it in the control source? Make sure it starts with the = sign!

 

[Rjc8513]

No, it's in the page header.

 

[ideafixer]

Yeah but you have to add a text box, and then set the control source to ="City " & [CITY] assuming city is part of your record source. Also be sure the text box name is not CITY... you need to change that to txtCity or something. You will get an error if you name the text box the same thing as a field in your record source.

Also, is city the same for every value in your record set? You will get a random occurance of city if it is different... you may want grouping levels if this is the case.

 

[Rjc8513]

Thanks ideafixer! Renaming the text box fixed the problem.