[AccessD] Memo field parsing

No, get the textwidth of the control and see if the textwidth of the
text is greater than that.  Handle the situation where it is not and
everything fits in the first control.  Otherwise get the text that fits
within the control textwidth and use instrRev to find the last space in
that substring.  Break it there.  At that point, you also know the index
of the starting point for the rest of the string, so all you need to do
for the next page is use the Mid(text, index) to put the rest of it into
the second page.

Charlotte Foust


-----Original Message-----
From: Gregg [mailto:greggs at msn.com] 
Sent: Wednesday, August 03, 2005 11:34 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Memo field parsing


So, you're saying I need to loop through all the characters until I find
the last whole word that will fit on the first line, the same for the
second etc. until I determine what text will fit in the first page text
field and use what's left for the 2nd page?
  ----- Original Message ----- 
  From: Charlotte Foust<mailto:cfoust at infostatsystems.com> 
  To: Access Developers discussion and problem
solving<mailto:accessd at databaseadvisors.com> 
  Sent: Wednesday, August 03, 2005 11:02 AM
  Subject: RE: [AccessD] Memo field parsing


  You can't do it by simply counting characters anyhow.  You have to use
  the TextWidth property, which can be expressed as
  reportname.TextWidth(stringvariable) and compare that to the textwidth
  of the control ( reportname.TextWidth(controlobject) or to the maximum
  length you want to display.  You'll also want to allow a padding
factor
  to avoid overrunning the  borders of the control and be sure and check
  for carriage returns because they confuse the issue.

  If you want to display 3 "lines", you'll have to break the memo field
  into the first three chunks that will fit into the textwidth of the
  textbox you're using to display the text on that page.

  Charlotte Foust


  -----Original Message-----
  From: Gregg [mailto:greggs at msn.com] 
  Sent: Wednesday, August 03, 2005 8:43 AM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Memo field parsing


  Charlotte

  Physical space I think because I don't know how to get from one to the
  other.  The number of characters is going to be dependant on the how
  many characters are lost to word wrapping isn't it?  Is there a way to
  calculate the number of characters that will appear in the first three
  lines?  If I knew that, I could do it.
    ----- Original Message ----- 
    From: Charlotte
Foust<mailto:cfoust at infostatsystems.com<mailto:cfoust at infostatsystems.co
m>> 
    To: Access Developers discussion and problem
 
solving<mailto:accessd at databaseadvisors.com<mailto:accessd at databaseadvis
ors.com>> 
    Sent: Wednesday, August 03, 2005 10:28 AM
    Subject: RE: [AccessD] Memo field parsing


    Define "first three lines".   Is that a particular number of
  characters
    or a physical space?

    Charlotte Foust


    -----Original Message-----
    From: Gregg [mailto:greggs at msn.com] 
    Sent: Wednesday, August 03, 2005 7:32 AM
    To: Access Developers discussion and problem solving
    Subject: [AccessD] Memo field parsing


    I would like to parse a memo field in a A97 report such that the
first
    three lines is on the first page and whatever is left is on the
next.
    Any ideas?

    Gregg Steinbrenner
    -- 
    AccessD mailing list
 
AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com<mailto:
AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>>
   
 
http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvi
<http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadv
i>
  sors.com/mailman/listinfo/accessd>
    Website:
 
http://www.databaseadvisors.com<http://www.databaseadvisors.com/<http://
www.databaseadvisors.com<http://www.databaseadvisors.com/>>
    -- 
    AccessD mailing list
 
AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com<mailto:
AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>>
   
 
http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvi
<http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadv
i>
  sors.com/mailman/listinfo/accessd>
    Website:
 
http://www.databaseadvisors.com<http://www.databaseadvisors.com/<http://
www.databaseadvisors.com<http://www.databaseadvisors.com/>>
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>
 
http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvi
sors.com/mailman/listinfo/accessd>
  Website:
http://www.databaseadvisors.com<http://www.databaseadvisors.com/>
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>
 
http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvi
sors.com/mailman/listinfo/accessd>
  Website:
http://www.databaseadvisors.com<http://www.databaseadvisors.com/>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com