> A little know trick in the report writer is to use a ";" and a "," between fields like this:
>
>Addr1;Addr2;City,State,Zip
>
>The ";" tells the report writer to add a CRLF between the two fields as long as the first field isn't blank. The "," tells the report writer to trim the two fields on either side, and then add a space between them .. but not if the first field is blank. So the above expression would get you the following if Addr2 is blank:
>
>Addr1
>City State Zip
>
>and it would get you the following if addr2 is filled in
>
>Addr1
>Addr2
>City State Zip
Wow - "little known" is definitely right in my case!
I wish that I'd known that about 10 years ago!!!!
Cheers,
Jamie