Software

Ask something
Discussion Locked

Querying memo fields in MS Access

0 helpful
1 reply

by john.strong

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
Pretty simple question: is there any way of running a query on a memo field in Access to search for words in a document beyond the 255 character limit? I have records in a field containing text entries of approx 1/2 to fullside A4 but a query search will only search the first 255 characters. Anything beyond this limit is not picked up. Is there any way round this limit in Access.
Thanks in anticipation

1 reply

by mslizny

No, the limit of 255 is set in Access. Have you considered creating some fields for key terms that you want to search on and using this in place of a query on the entire memo field?

This discussion is closed to new replies.