[AccessD] Memo field parsing

That was exactly my first solution (naff or not).  The problem is the text box is midway down the 2nd page following some other items and the customer never was very impressed with the blank space.  Now they are running out of space on the second page and are limited to the 2 pages by their end user and need to use the blank space.
  ----- Original Message ----- 
  From: Andy Lacey<mailto:andy at minstersystems.co.uk> 
  To: Access Developers discussion and problem solving<mailto:accessd at databaseadvisors.com> 
  Sent: Wednesday, August 03, 2005 11:08 AM
  Subject: Re: [AccessD] Memo field parsing


  This may sound a naff solution but I reckon any clever one is going to be a
  lot of work. So this is a pragmatic workaround.

  Obviously getting the first 3 lines on the first page is easy. You just size
  your textbox to 3 lines height and make it not grow. Then I was thinking
  about the second part and thought....if you place a full height (or CanGrow)
  text control on page 2 it will show the first 3 lines again and then the
  rest. So if you can't stop it showing the first 3 lines can you blank them
  out? As long as you don't want the control on page 2 to be too close to the
  top of the sheet you just place another (empty) control, again of 3 lines
  height over the top of it (with background not transparent). Seems to work.
  --
  Andy Lacey
  http://www.minstersystems.co.uk<http://www.minstersystems.co.uk/>




  --------- Original Message --------
  From: "Access Developers discussion and problem solving"
  <accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>
  To: "accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>" <accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>
  Subject: Re: [AccessD] Memo field parsing
  Date: 03/08/05 15:57


  Hi Gregg

  You may find some hints about font metrics here at Stephen Lebans:

  http://www.lebans.com/textwidth-height.htm<http://www.lebans.com/textwidth-height.htm>

  Prepare for some fun ...

  /gustav

  >>> greggs at msn.com<mailto:greggs at msn.com> 08/03 5:42 pm >>>
  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.

  --
  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/>

  ________________________________________________
  Message sent using UebiMiau 2.7.2

  -- 
  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/>