[AccessD] Memo field parsing

Gregg greggs at msn.com
Wed Aug 3 13:34:29 CDT 2005


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.com>> 
    To: Access Developers discussion and problem
  solving<mailto:accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.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://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