Nov 14, 2005 #1 agreen10 IS-IT--Management Oct 20, 2005 70 US Hi, I am trying to split up an address formula to print on seperate lines. Is there a specific syntax that I can use to accomplish this? {streetaddress} &" "& }CityStateZip} but this will gave me one line. I want them to appear on two seperate lines.
Hi, I am trying to split up an address formula to print on seperate lines. Is there a specific syntax that I can use to accomplish this? {streetaddress} &" "& }CityStateZip} but this will gave me one line. I want them to appear on two seperate lines.
Nov 14, 2005 #2 Madawc Programmer Sep 5, 2002 7,628 GB Try {streetaddress} & CHR(13) & {CityStateZip}. Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 Upvote 0 Downvote
Try {streetaddress} & CHR(13) & {CityStateZip}. Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
Nov 14, 2005 #3 Madawc Programmer Sep 5, 2002 7,628 GB You can also drop both fields into a text box, and sepatate them by a carriage return. Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 Upvote 0 Downvote
You can also drop both fields into a text box, and sepatate them by a carriage return. Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
Nov 14, 2005 Thread starter #4 agreen10 IS-IT--Management Oct 20, 2005 70 US It worked, thank you very much Upvote 0 Downvote