[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> 
  To: Access Developers discussion and problem
solving<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>
 
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