Controlling field width?

[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

 

[Guest]

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 " ".

 

[Allen Browne]

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.