Report cutting off data - Access 2013

[mdnikki]

Hello I am a report that has a notes column. It is pulling from a query and the query has the full data in that column but in the report it is cutting it off at 255 characters. Since this version of Access doesn't have a memo field any ideas how I can get the full note to pull into the report.



Thanks

[ranman256]

all versions have a memo field. The 'new' memo is called LONG TEXT.
are you using this?

queries sometimes will truncate the field to 255. (thanks microsoft)

[mdnikki]

Yes I am using long text. When I look at the query the full text is in there, that is the weird thing.

[ranman256]

but the report field is truncating?
is it set to CAN GROW = TRUE?

[mdnikki]

Yes it is set to can grow and can shrink. Although I have been told that has nothing to do with when you go over 255 characters. That really only applies when its under.

[ranman256]

that 255 'bug' has been around a while. Microsoft didnt think we needed all the data.

[mdnikki]

Yes it is set to can grow and can shrink. Although I have been told that has nothing to do with when you go over 255 characters. That really only applies when its under.

[isladogs]

There are several reasons why memo fields can get truncated.
See Allen Browne's explanation http://allenbrowne.com/ser-63.html