Mulitple fields in one box

  • Thread starter Thread starter John K.
  • Start date Start date
J

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.
 
Use one text box named "txtFullName" and set its control source to:
=[LastName] & ", " & [FirstName] & " " & [MidInit] + "."
 
Back
Top