Form Field Limiting Characters for Memo Type?

[Guest]

I have a form field that is referencing a field in a table that is set to
MEMO type. However, when I enter data into the form field, there is a limit
to the number of characters that are allowed.

Is this a limitation of Access? If not, how do I get around this?

Thank you in advance for your help.

G

 

[Allen Browne]

The text box should be about to accept around 64000 characters of text in
all versions of Access. That's around 8 letter-sized pages of single-spaced,
printed text. Are you inserting more than that?

 

[Guest]

No, we're maxing out at 255 characters.

The text box should be about to accept around 64000 characters of text in
all versions of Access. That's around 8 letter-sized pages of single-spaced,
printed text. Are you inserting more than that?

 

[Allen Browne]

Remove anything from the Format property of the text box on the report, and
anything in the Format property of the field in the table.

If that is not the issue, perhaps the form is based on a query that performs
some kind of aggregation, e.g. a DISTINCT predicate or GROUP BY clause.