Autofit fields in Access

[xian2]

Hi All,

Am trying to create a report and have three fields that need to go next to each other - Title, FirstName, LastName but when they show up on the report the spacing between them in uneven and looks unprofessional.

I was wondering if there is a way of putting them next to each other so they only use the space they need to and have just one space between each.

Also, using design view, I would like the address to appear without any gaps in it as the form has:
Address 1
Address 2
State
County
Post Code
Country

And not everyone has all of those lines and I would not like gaps to appear where there are blanks.

Many thanks in advance for your kind help

Edd

[ADezii]

Hi All,

Am trying to create a report and have three fields that need to go next to each other - Title, FirstName, LastName but when they show up on the report the spacing between them in uneven and looks unprofessional.

I was wondering if there is a way of putting them next to each other so they only use the space they need to and have just one space between each.

Also, using design view, I would like the address to appear without any gaps in it as the form has:
Address 1
Address 2
State
County
Post Code
Country

And not everyone has all of those lines and I would not like gaps to appear where there are blanks.

Many thanks in advance for your kind help

Edd

__1. In the underlying Record Source for the Report, create a Calculated Field called FullName as indicated in the code block below:

FullName: Trim([Title] & " " & [FirstName] & " " & [LastName])

__2. Eliminate the Title, FirstName, and LastName Text Boxes that you would like to have next to each other.
__3. Add a single Text Box and set its Control Source equal to the FullName Field.
__4. All Name Fields in each Record should now be more appropriately positioned as indicated below.

Sample Output:

Mr. David Abecunas
James Alberici
Eric Allen
Mr. Joseph Andrews
Lawrence Appiott
Medlen Arevalo
Sir David Armella
Andrew Baldwin
Harry Bannan
Edward Bayer
Thomas Beck
Lawrence Belitsky
Daniel Bennett
John Bilkins
Thomas Bitto
Matthew Black
Francis Boettcher

[xian2]

Excellent,
Thank you so much for your help.
Best wishes
Edd