Synchronize Text Boxes in a Row

[Bob Sanderson]

I have a form with several fields in-line in the detail. I am using the
borders of each text box to form a grid. The resultant output resembles a
spreadsheet. The problem I'm having is that in the text in one field is
too long for the text box to display, the box expands vertically (it's set
to "can grow"). This would be ok if the adjacent cells would expand as
well so that the borders still line up. Instead, the single box grows to
two lines but rest remain as one line. I guess what I want to do is to
somehow link all of the text boxes in the row so that they all expand
together. Can that be done?

[Larry Linson]

Re: Synchronize Text Boxes in a Row

It appears you have discovered that you can't do what you want using the
borders of the text boxes. But, you're likely to find something useful in
re: lines on reports at MVP Stephen Lebans' site, http://www.lebans.com.

Larry Linson
Microsoft Access MVP

"Bob Sanderson" <xnews@LUVSPAMs andmansoftware. com> wrote in message
news:Xns93F2E9E 5368E0sandmanLU VSPAMsandma@167 .206.3.3...[color=blue]
> I have a form with several fields in-line in the detail. I am using the
> borders of each text box to form a grid. The resultant output resembles a
> spreadsheet. The problem I'm having is that in the text in one field is
> too long for the text box to display, the box expands vertically (it's set
> to "can grow"). This would be ok if the adjacent cells would expand as
> well so that the borders still line up. Instead, the single box grows to
> two lines but rest remain as one line. I guess what I want to do is to
> somehow link all of the text boxes in the row so that they all expand
> together. Can that be done?[/color]