I have an unbound field which prints the concatenated fields for the lables. I use the =IIf([Address2] Is Null,[Address2],[Address2] & ", " & [Address2])to ignore blank fields which is fine but it prints the address in one long line. How can I enter a return between field names?

Take a peek at this article. I think this is what you are looking for.... http://support.microsoft.com/support/kb/articles/Q95/3/90.asp?PR=ACC

HTH,
Jack

Thanks, just what I wanted.
DBL

Tried the code given in the sample and it seemed to be working well. However, it started to interfer with a macro I had to open the report the module was in and run an update query. I then found I could not get in to the report in preview mode. Design mode was all I could get into. Checked code and everything is fine. Any ideas? By the way, it's 2000 I'm working in.

Dawn -

Not just exactly sure how the Macro, Function and Update Query are related. The Function is called by the report so I am not sure how the Update query is involved. I know what the Macro does and I would suggest that you remove the Macro and use code in the event that opens the Report. The code should look something like this: DoCmd.OpenReport "rptReportName", acViewNormal. This will print the report. Do not know what to say about the Update Query so if you would like to email me directly (easier for me to keep track of what you are trying to do rather than checking back here all the time) I will try and help you out. I am still using Access97 but what you are doing should be very similar to what I might be able to suggest to you....

Jack