[AccessD] Memo field parsing

Gregg greggs at msn.com
Wed Aug 3 17:49:20 CDT 2005 

Thanks Charlotte!  I give it a try.
  ----- 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 5:33 PM
  Subject: RE: [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<mailto:cfoust at infostatsystems.com>> 
    To: Access Developers discussion and problem
  solving<mailto:accessd at databaseadvisors.com<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<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<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<mailto:AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com<mailto>:
  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://databaseadvi>
  <http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadv<http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadv>
  i>
    sors.com/mailman/listinfo/accessd>
      Website:
   
  http://www.databaseadvisors.com<http://www.databaseadvisors.com/<http://<http://www.databaseadvisors.com<http://www.databaseadvisors.com/<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<mailto:AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com<mailto>:
  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://databaseadvi>
  <http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadv<http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadv>
  i>
    sors.com/mailman/listinfo/accessd>
      Website:
   
  http://www.databaseadvisors.com<http://www.databaseadvisors.com/<http://<http://www.databaseadvisors.com<http://www.databaseadvisors.com/<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://databaseadvi>
  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://databaseadvi>
  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://databaseadvisors.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://databaseadvisors.com/mailman/listinfo/accessd>
  Website: http://www.databaseadvisors.com<http://www.databaseadvisors.com/>

More information about the AccessD mailing list