Gap between Mr & David

[Slater]

Hi Guys and Girls,

Hope you can help me out and stop me looking like .

I'm printing out some envelopes. At the min, when it's printing a title and first name i get Mr(GAP)David(GAP)Smith because i've put a " " inbetween the fields in the layout - which is all very well and good. When the person doesn't have a title though, the (GAP) is still there, and so pushes the rest of the name out to the right by one space.

So my question is, how do i get rid of this gap when there isn't a title, but yet retain it when there is? I was thinking of making a field (say "Gap") that checks whether there is anything in the title field, and if there is putting a space into it, but there must be a more simple way!

my layout looks like:

<<Title>> <<FName>> (with a space between)

so i could make it:

<<Title>><<Gap>><<FName>>

and GAP has a space entered in it when Title has something in it, but there must be an easier way ...

Thanks for any help!

slater

[Ender]

Use a Full Name calc field:

case(not isempty(Title),Title & " ") & FName & " " & LName

[Slater]

Thanks Ender ... i'm just off out, but i'll give it a go as soon as poss.

There are so many little bits and bobs to know, so thank you!

slater