Trimming fields in report format

[dickjo5]

I maintain a database of golfers and I would like to output a membership roster. When setting up the format in the design view, I line the fields on the grid as closely as possible, but I still get a lot of space between, say, last name, first name. I.e., The output is JONES, David J. and, of course, I want JONES, David J.
How do I trim the fields to allow for longer or shorter names?
Thanks,
Dick J.

 

[dickjo5]

See what I mean? The email tirms the spaces I intentionally left in my message. The first JONES, David J. should have left spaces between JONES and David J. My report looks like this (where periods are equated to spaces): JONES, .............David J. I want it to show JONES, David J.

 

[Marc VV]

Instead of using 2 unbounded fields [last name] and [first name] next to eacht other, put 1 unbounded field in your report, with data source:
=[last name] & ", " & [first name]

Don't forget the "=".

This will do the job.

Marc

 

[dickjo5]

Many thanks, Marc. Works like a charm. This forum is absolutely awsome in helping a newbie like me.
Dick J