OT-Crystal-Mailing Labels-City,State

Create a formula field then in the formula editor copy and paste the
statement I added below

TRIM({Customer.City}) + ", " + TRIM({Customer.State}) + " " + TRIM
({Customer.Zip})

Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com

--- In vantage@yahoogroups.com, Dan Shallbetter <dans@s...> wrote:
> Ann,
>
> You might be able to change the horizontal alignment (right on
city & left
> on State) to get the desired results. Right click on the field tab
alignment
> is on the general tab.
>
> Dan Shallbetter
> States Electric
>
> -----Original Message-----
> From: amfabllc [mailto:amfab@a...]
> Sent: Thursday, March 17, 2005 2:26 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] OT-Crystal-Mailing Labels-City,State
>
>
>
> How do you get City, State to print without the extra spaces so it
> does not look like:
> City , State
>
> Thank you
> Ann Rohyans
> AMFAB
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
How do you get City, State to print without the extra spaces so it
does not look like:
City , State

Thank you
Ann Rohyans
AMFAB
Yi think it is the trim function

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: amfabllc [mailto:amfab@...]
Sent: Thursday, March 17, 2005 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT-Crystal-Mailing Labels-City,State




How do you get City, State to print without the extra spaces so it
does not look like:
City , State

Thank you
Ann Rohyans
AMFAB





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
Ann,

You might be able to change the horizontal alignment (right on city & left
on State) to get the desired results. Right click on the field tab alignment
is on the general tab.

Dan Shallbetter
States Electric

-----Original Message-----
From: amfabllc [mailto:amfab@...]
Sent: Thursday, March 17, 2005 2:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT-Crystal-Mailing Labels-City,State



How do you get City, State to print without the extra spaces so it
does not look like:
City , State

Thank you
Ann Rohyans
AMFAB









[Non-text portions of this message have been removed]