I'd say its not a memo field, since you can't do distinct operations on a memo/blob/etc.
Are you sure its not a text field (which has a maximum of 255 chars in access)? Taz > Why am I only getting the first 255 characters from an Access DB memo > field when I do a select query? I have enabled Long text retrieval and > the long text buffer is set to 65000, the blob buffer is set to 64000 > bytes. > This is the query: -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
