Formula formatting

[jenschmidt]

I have created a formula which outputs a title for the page header of a report. It returns the following:

For Post Period: July to December 2003
For Last Post Period: July to December 2002

It is one formula, but I don't know how to force it to go to a second line in the middle of the formula. The formula is basically a concatenation of text and formulas.

Thanks!


jennifer.giemza@uwmf.wisc.edu

 

[BobMarley]

use CHR(13) in your formula


FOrmula = "This is the first line" & CHR(13) & "This is the second line

 

[jenschmidt]

PERFECT!! Thank you!!

jennifer.giemza@uwmf.wisc.edu