Is it possible for text boxes to automatically align to each other horizontally?

[LMH]

Hello, I am new to using Access and apologize if I'm not using the correct terminology. I am trying to create a report where a field is inserted in the center of a title. Specifically, the following:



In the Court of Common Pleas of [County Name] County, Pennsylvania

So my text box layouts are as follows:

[In the Court of Common Pleas of] [Field = County Name] [County, Pennsylvania]

Since the county name will change in length, I'm hoping there is a way to have the last text box automatically align to the size of the field. I've already enabled the can grow and can shrink functions on both. But I'm still getting the following.

In the Court of Common Pleas Mercer ___________ County, Pennsylvania (unwanted space)

In the Court of Common Pleas of Alleghe County, Pennsylvania (not enough space). In this example, I want "County, Pennsylvania" to move down to the next row.
___________________________ny

I've checked my reference book and searched the web, but no answers. Thanks.

[pbaldy]

How about a textbox control source of:

="In the Court of Common Pleas of " & [County Name] & " County, Pennsylvania"

[LMH]

Wow, yes, this is a much better way to approach the problem. Thanks for helping a newbie out.

[Micron]

FYI - Can Grow & Shrink refers to the vertical height, not width, and if I'm not mistaken, only applies in print preview or actual printing. I don't bother much with report view, so am not positive.

[pbaldy]

Wow, yes, this is a much better way to approach the problem. Thanks for helping a newbie out.

Happy to help and welcome to the site by the way!