Removing unwanted carriage return at end of text ?

[Steven Cappiello]

Could someone please share with me how I can prevent the user from entering carriage returns at the end of a text field ?

or

Could someone please share with me how I could remove unwanted trailing carriage returns (that are followed by a blank line).

--- my exact problem is this:

2 fields:

street address

city, state, zip (combined from other fields)

On certain records, my users have entered a blank line after the text they've entered in the street address field, so my letter and envelope looks like this:

Tom Smith

12 Park Place

Box 479

New York, NY, 10021

what's the best way to avoid or deal with this ?

Thanks

[-Queue-]

You can use a field validation of not Position( field, "

[Steven Cappiello]

uh oh.. I'm kind of a newbie..

could you be a little more specific about how I use not Position(field, "

[-Queue-]

In Define Fields, select your field and click Options. Select the Validation tab and click 'Validated by calculation'. In the resulting dialog box, enter either not Position( fieldname, "

[Steven Cappiello]

thank you..but... the problem with this is..

The field does have some valid carriage returns in it.

I don't want to test for carriage returns.. but only for those occurrences where a carriage return is followed by a blank line..

from my original post:

Tom Smith <---- all this (Tom Smith, 12 Park Place, Box 479, and that last carriage return)

12 Park Place are from one field... the last space is because the data enterer

Box 479 hit return one time too many... how do i get rid of that extra "return"

so there is no space before the 2nd field

New York, NY, 10021 <-- this is from the 2nd field when i use merge fields on my form letter ?

[Ender]

This would work to strip off one carriage return off the end of Address:

If(Right(Address,1)="

[RalphL]

Try:

Case(Right(Text,1)=

[Ugo DI LUCA]

Or Substitute(YourAdress& "|" ,"

[JW]

See if the 'Trim' function can do something for you....