Discussion Locked

Microsoft Access 2002 can grow field

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I can not get my field to grow in my access 2002 report even though the can grow field property is set to yes. My report runs off a query. The field is being limited to 255 charcters, related to a text field, however mine is a memo field and should be able to show 65K characters. If the report runs off a table, then the field works fine, its only when I use the query does my field get truncated. I am interested in the filter property but have not been successful on using that option either.

1 reply

by desktroll

There can be an issue with truncating data at the 255 character mark in reports when a format of ">" setting the text to uppercase is set.

Check your formatting and see if this applies. Also check the source query to see if all data appears in there as well.

This discussion is closed to new replies.