Question on text boxes in reports

[hammerva]

Is there a way to shrink or grow horizontaly based on the data of a text box? I know you can grow and/or shrink veritically but I would rather be able to shrink the other way because of the different size of data in this text box

Thanks

 

[cfmiles]

If you have other fields on the horizontal that you want to push or pull based on the size of the field, the best way I know to do this is to combine the fields.

=[Field1] & " " & [Field2] & " " & [Field3]

Then you make the box as long as you want and the data will always have the appropriate spacing.