General discussion

Locked

Querying memo fields in MS Access

By john.strong ·
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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by mslizny In reply to Querying memo fields in M ...

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?

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums