Report Field character limitation

  • Thread starter Thread starter Richard John
  • Start date Start date
R

Richard John

Is anyone aware of a character limit on text fields in Access Reports? I've
only just realised that a text field in one of my reports is truncating
characters beyond 255 chars. Never encountered this before. The data for the
field is being sourced from a Memo field and consists of free form textual
responses from clients participating in a feedback survey. The field's

*Can Grow* and *Can Shrink* properties are set to on.

Thanks
 
Are you using any functions on the field in question? Most of the string
functions will only return the first 255 characters.
 
Thanks for that Douglas. Doubt I'd have thought of that. Good call. I did
have a function in the Access QBE merging the values of two fields into one
(I presume that counts as a function call). When I made the same function
(=[Resp] & " (" & [Formnumber] & ")") the Control Source of the *Report
Text field*, it worked, though. So, the contruct didn't work in the QBE but
worked in a Report control ... strange :-)

RJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo Field in Table Truncated in query results and in report 1
Field Sizes 5
text box in report is truncating memo field at 255 characters 2
Running Query on memo field - character limit 4
Text character limits 6
Strange Asian looking characters in output 3
Exporting data from Access to Excel 1
Truncated memo field display 3

Back
Top