Memo Fields (Long Text - 2016)

[FrostByte]

Hi All,

So I have a simple query that returns various data (including a Long Text field), except the field cuts off at 249 characters.

Anyone come across this?
Is there a solution for this?

I'm using Access 2016


Thanks in advance
Steve

 

[Minty]

This is a common problem.

A majority of the best reasons and workarounds are listed here http://allenbrowne.com/ser-63.html

Bookmark the site - it's got loads of very useful things on it.