Formatting of Mailing Labels (Quick Question)

[scarlo]

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)

First Name Last Name

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

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

Any suggestions? Thanks.

 

[Trevil]

1. Why not set the 'Can Grow' & 'Can Shrink' properties to 'Yes' for your text boxes on the report.

or 2. Change your input query to concatenate the two fields. I'm not sure where you tried '=[first name]&[last name]' but it returns -1 because it evaluated the expression!

"Have a great day today and a better day tomorrow!

 

[scarlo]

Thanks Trevil- however I tried the Shrink and Grow already and it doesn't seem to make much difference. It actually adds the cutoff info to the next line down e.g.

ChristophConklin
er

As far as concentrating the two fields, how would I go about doing that?

 

[Trevil]

Just change your query that supplies the data to include something like the following (note that you would need to set the Control Source of your text box to 'FullName'):

SELECT [FirstName] & " " & [LastName] AS FullName
FROM MyTable;

Or for Last Name, First Name:

SELECT [LastName] & ", " & [FirstName] AS FullName
FROM MyTable;



"Have a great day today and a better day tomorrow!