I've put fields right next to each other in a Report and set their widths...

But when I display the Report the fields are spaced farther apart and take
up to much horizontal space.

What am I missing?

thanks for any help.

Will

The actual width a control needs depends on the data it contains.

If you want to jam them up, you might concatenat the fields into one control
e.g.:
=Trim([Title] & " " & [FirstName] & " " & [Surname])

Be sure to set the Name property of this control so it does not match the
name of a field. Access gets confused if the text box has the same name as a
field, but it is bound to something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Will" <(E-Mail Removed)> wrote in message
news:CLgAf.12653$(E-Mail Removed)...
> I've put fields right next to each other in a Report and set their
> widths...
>
> But when I display the Report the fields are spaced farther apart and take
> up to much horizontal space.

Thanks Allen.

Will

"Allen Browne" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The actual width a control needs depends on the data it contains.
>
> If you want to jam them up, you might concatenat the fields into one
> control e.g.:
> =Trim([Title] & " " & [FirstName] & " " & [Surname])
>
> Be sure to set the Name property of this control so it does not match the
> name of a field. Access gets confused if the text box has the same name as
> a field, but it is bound to something else.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Will" <(E-Mail Removed)> wrote in message
> news:CLgAf.12653$(E-Mail Removed)...
>> I've put fields right next to each other in a Report and set their
>> widths...
>>
>> But when I display the Report the fields are spaced farther apart and
>> take up to much horizontal space.
>
>