Mulitple fields in one box

[John K.]

I have a report that shows first name, middle, and last
names at the top of each page (for mailing). How can I
combine all three fields into one so they resize. The
same as a label report. Right now each is its own field,
so when I have a short last name, there is a gap. Hope
this explains it..............

Example

Doe, John L.
verses
Doe, John L.

 

[Duane Hookom]

Use one text box named "txtFullName" and set its control source to:
=[LastName] & ", " & [FirstName] & " " & [MidInit] + "."