How to control Horz Spacing on Reports

[Will]

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

 

[Allen Browne]

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.

 

[Will]

Thanks Allen.

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.

Reply to group, rather than allenbrowne at mvps dot org.

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.