Formula Assistance 1

[TechUser23]

I think I need a formula versus using a text box in this scenario. I used a text box and dragged over the CustomerFirst, CustomerMiddle and CustomerLast Name fields. Whats happening now is if the customer doesnt have a middle name, its putting an extra space between the First and Last Names. Can I suppress the middle somehow if no middle name is there?

My fields:

CustomerFirst
CustomerMiddle
CustomerLast

 

[dgillz]

Dump the text box. Too clumsy. Write a formula:

{FirstName}&" "&
if isnull({MiddleName}) then " " else {MiddleName}&" "&
{LastName}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[TechUser23]

Thanks ... just what I needed.

 

[Turkbear]

HI,
OR ( there is always an Or)

After placing the fields in the text box, right-click on the box ( not on any of the included fields) and, using the format text option, select 'suppress embedded field blank lines'..

This is what is used for mailing Labels, for instance., where some may have more address lines than others..







To Paraphrase:"The Help you get is proportional to the Help you give.."