Formatting Labels Quick Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scarlo - 29 Jul 2005 21:47 GMT

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

Reply to this Message

Duane Hookom - 30 Jul 2005 03:33 GMT

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.

Signature

Duane Hookom
MS Access MVP

> In my Mailing Label report I have two boxes next to each other (and
> several other boxes above and below which all work out fine)
[quoted text clipped - 9 lines]
>
> Any suggestions? Thanks.

Reply to this Message