[AccessD] Memo Fields and Reports in Access 97

A.D.Tejpal adtp at touchtelindia.net
Wed Apr 28 22:56:52 CDT 2004


    On the subject of memo fields in reports, another interesting feature is pertinent - 

    If the field content is larger than one page, and 'Keep Together' property of Detail section is set as 'Yes', the Report Formatting process is prone to hang up Indefinitely.

    Conclusion - For large Memo Fields in a report, set the 'Keep Together' property of Detail section as 'No'
A.D.Tejpal
--------------
  ----- Original Message ----- 
  From: Elam, Debbie 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, April 29, 2004 02:22
  Subject: RE: [AccessD] Memo Fields and Reports in Access 97


  Set the field to be able to grow.  It will expand to fit everything.

  Debbie

  -----Original Message-----
  From: Jeff Barrows [mailto:Jeff at outbaktech.com] 
  Sent: Wednesday, April 28, 2004 3:43 PM
  To: Access Developers discussion and problem solving
  Subject: RE: [AccessD] Memo Fields and Reports in Access 97

  OK, I stated my question wrong.  I have a report in access 97 that needs to display the contents of a memo field.  How can I do this without some (most) of my data being dropped?

  -----Original Message----- 
  From: Tesiny, Ed [mailto:EdTesiny at oasas.state.ny.us] 
  Sent: Wed 4/28/2004 3:27 PM 
  To: Access Developers discussion and problem solving 
  Cc: 
  Subject: RE: [AccessD] Memo Fields and Reports in Access 97

  For memo fields the max. number of characters is 64,000.

  Ed Tesiny
  EdTesiny at oasas.state.ny.us

  -----Original Message-----
  From: Jeff Barrows [mailto:Jeff at OUTBAKTech.com]
  Sent: Wednesday, April 28, 2004 4:23 PM
  To: AccessD
  Subject: [AccessD] Memo Fields and Reports in Access 97

  It has been a while since I needed to add a memo field to a report
  and I
  cannot seem to remember, is the memo field limited to 255 char. on
  the
  report?  And if so, could it then limit my memo field to the same
  255
  chars?

  TIA

  Jeff Barrows 




More information about the AccessD mailing list