Re: Is it possible to link two text boxes...

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"b" <b@xxxxx> wrote in message news:OyT2ZhRrGHA.4356@xxxxxxxxxxxxxxxxxxxxxxx
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

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:e0qsaLRrGHA.2452@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"b" <b@xxxxx> wrote in message
news:u2FmLmQrGHA.3856@xxxxxxxxxxxxxxxxxxxxxxx
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.







.

Relevant Pages

  • Re: Is it possible to link two text boxes...
    ... SELECT MyTextField AS Field1, MyTextField AS Field2 ... of the information and the second box display any left over text from the ... they will overlap the images. ...
    (microsoft.public.access.reports)
  • Re: Append import data to existing record
    ... (I'm sure I need to exchange Field1 with my actual field name but what about ... > or query with values from a non-updatable table or query - even though ... > in the text file - is to write VBA code that uses recordset operations ... > to read the data from the text file and update the subform table. ...
    (microsoft.public.access.externaldata)
  • Re: Group By, Max and Min
    ... SELECT field1, field2, field3, LAST, MIN, MAX ... I have (from a previous saved query) these fields: ...
    (microsoft.public.access.queries)
  • Re: query or script
    ... I want to select the whole record if the value in field1 is ... selects only the two important fields, with the distinct property ... Convert that into an Append query, ... If you need one value from field2, we'll need to know how to ...
    (comp.databases.ms-access)
  • Re: Create Weekly and Monthly Flag in database/table
    ... WHERE field1 In; ... the weekday(datefield [,optional first day of week)) returns a ... In the query designer if you put your field2, ... small table with the holidays that fall on a friday. ...
    (comp.databases.ms-access)
Loading