Report Field character limitation

[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

 

[Douglas J Steele]

Are you using any functions on the field in question? Most of the string
functions will only return the first 255 characters.

 

[Richard John]

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