Hello,

I have the following first line in my label:

<<Prefix>> <<FirstName>> <<LastName>>

My problem is that not all records have a prefix and for those records I get the blank space before FirstName. How can I get rid of this space?

thanks!

Stephanie

[email protected]

Create a Calculation field with result is text = If(IsEmpty(Prefix); FirstName; Prefix & " " & FirstName)

Use regular fields and the Slide Left Function. It looks like the devil in Browse, but when viewing in Preview and Printing it does what you want.

In Layout Mode, select the fields that need to slide and then go to the Menu >> Format >> Slide / Printing. It's the button on the left in the Menu that will pop up.

HTH

Lee