Formatting Labels Quick Question

  • Thread starter Thread starter scarlo
  • Start date Start date
S

scarlo

In my Mailing Label report I have two boxes next to each other (an
several other boxes above and below which all work out fine

First Name Last Nam

How do I code it so that they are both in the same box? If I ca
figure this out it will prevent there from being a large spac
between them if the first name is short.

I tried
=[first name]&[last name] but the output is a "-1".

Any suggestions? Thanks
 
I find if very hard to understand how combining two text fields would result
in "-1". A control source like
=[first name] = [first name]
would result in -1.
 
Back
Top