Controlling field width?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields in a report that are printed next to each other. Field 1
prints various text based on certain conditions and varies in length, ie 1 -
4 words. Field 2 prints next to it. If I give Field 1 enough space to print
its max length it leaves a lot of blank space between Field 1 and 2 when
Field 1 prints its minimum length.

Example: "Field 1 is this long Field 2"
"Field 1 Field 2"

How do I get rid of the extra space when needed?

Thanks Scott
 
Replace the two fields in your report with a new text box. In the control
source for your new text box:

=[field1]&" "&[Field2]

this will give you one space between the fields no matter their length based
on one space between the " ".
 
Use one text box with a Control Source of:
=[Field1] & " " & [Field2]

Also change the Name of this text box (on the Other tab of the Properties
box.) Access gets confused if the control has the same name as a field, but
is bound to something else.
 
Back
Top