Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Formatting addresses in reports

0 views
Skip to first unread message

David Horoschak

unread,
Feb 17, 1998, 3:00:00 AM2/17/98
to

I have a question about how best to format addresses in reports. In the
last line of an address (city, state zip) I'm forced to make the city
field really big in order to accomodate long city names. When I get a
short city name, however, that leaves a really long space before the
state. I have the same problem when printing a colon after "Dear Joe
Smith". Any help would be appreciated.
- Dave

--

+------------------------------------------------------------------
Dave Horoschak -aka- dth...@psu.edu - Owner/Engineer -
deciBel Productions (800) 707-0519 Phone / (800) 825-7061 Fax
Providing sound & lighting for the entire entertainment industry.
+------------------------------------------------------------------

Jose F Hernandez

unread,
Feb 20, 1998, 3:00:00 AM2/20/98
to

Try the following in a text box you can use the same format for the heading
use the Expression builder. =([City] & "," & [State] & " " & [Zip])
David Horoschak wrote in message <34E9C536...@psu.edu>...

Phil Hirons, Jr.

unread,
Feb 20, 1998, 3:00:00 AM2/20/98
to

Tribe

unread,
Feb 21, 1998, 3:00:00 AM2/21/98
to

You will want to use the Trim function, check the online help for some
examples (or do what I do and make a quick label report using the
wizards and then cut and paste that where you want it).

On Tue, 17 Feb 1998 12:13:26 -0500, David Horoschak <dth...@psu.edu>
wrote:

0 new messages