I have a report that displays First Name and Last Name pulled from a query. When the first name and last name print, I would like the white space to trim.

I know that the "can shrink" and "can grow" will control vertical spacing, but is there a way to control the horizontal spacing?

[This message has been edited by Kimi (edited 04-25-2000).]

Create another field within your query as follows:
Name: [First Name] & " " & [Last Name]
and use this new field in your report.

Change your field names as required. This will merge both names within 1 field with a space between the first and last name.

Good luck.

That is exactly what I needed! Thank you so much for your help and the fast service, too!