Mackin, Christopher
CMackin at Quiznos.com
Wed Apr 28 15:40:50 CDT 2004
It's limited when used with a GROUP BY or DISTINCT SQL statement as the recordsource. All you need to do is, if you require DISTINCT OR GROUP BY, leave the PK to the Memo field in that query, then, at the highlest level of your query link back to the Memo field and grab it there. Chris Mackin -----Original Message----- From: Jeff Barrows [mailto:Jeff at outbaktech.com] Sent: Wednesday, April 28, 2004 2: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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com