Is it possible to link two text boxes...

  • Thread starter Thread starter b
  • Start date Start date
B

b

Is it possible to link two text boxes so that the text retreived from the
record or query flows into the next text box if it runs out of space in the
first box.
 
Text boxes don't "run out of space": there's effectively no limit to how
much text a text box can hold. Make sure you have the Can Grow property set.
 
Thank you for the quick reply, but I understand the grow concept, and that
the text box is not running out of space. The reason for the two text box
question is that I have two images on the page and one is justified left and
the other is justified right. This layout gives a checkerboard affect on the
page and I have basically four square areas. In the blank area opposite each
image I have a text box. Each box is taken from the same field in the
database. Currently when I link them both to the field it repeats the
information in each text box. I would like it if it is possible, to make the
first box display the first half of the information and the second box
display any left over text from the field that could not fit into the first
box. The boxes cannot grow or they will overlap the images.

Thank for the help anyway,
Steve
 
The only thing I can think of would be to divide the text in the query.

Instead of

SELECT MyTextField AS Field1, MyTextField AS Field2

try

SELECT Left(MyTextField, Len(MyTextField)/2) AS Field1, Mid(MyTextField,
Len(MyTextField)/2 + 1) AS Field2

to split them evenly between the two fields, or

SELECT Left(MyTextField, 500) AS Field1, Mid(MyTextField, 501) AS Field2

to fix how much is in the first box.

Of course, the code above will split in the middle of words. You could write
a function to pick the end of the first word that meets the criteria.
 
Thanks for your time and input.

Douglas J. Steele said:
The only thing I can think of would be to divide the text in the query.

Instead of

SELECT MyTextField AS Field1, MyTextField AS Field2

try

SELECT Left(MyTextField, Len(MyTextField)/2) AS Field1, Mid(MyTextField,
Len(MyTextField)/2 + 1) AS Field2

to split them evenly between the two fields, or

SELECT Left(MyTextField, 500) AS Field1, Mid(MyTextField, 501) AS Field2

to fix how much is in the first box.

Of course, the code above will split in the middle of words. You could
write a function to pick the end of the first word that meets the
criteria.
Click to expand...
 
Back
Top