Combining Fields on a Report

[vincet2009]

Hello,

I am wondering how to go about combining 2 fields on a report. Here's is an example of what I am trying to do.

Lets say I have a field called city and a field called state. On the report instead of having 2 fields print out, one for city and one for state, I would like to know if I could combine the two in the city field. In other words on the city field, could have the city print out and then a comma and then the state.

Thanks

 

[Alansidman]

In your Report, add a text box. In the properties for the text box, click on Data and then Conrol Source. In the Control Source type =[Cityfield] & "," & [Statefield]

alan

 

[vincet2009]

Great. Thank you that worked. What about if I want to put the city on one line and the state on the other. Then what would I type in?

Thanks

 

[Alansidman]

Look at this thread.

http://www.access-programmers.co.uk/forums/showthread.php?t=153336&highlight=Carriage+Return

Alan