Sorry for the long delay responding...been eating a lot of turkey lately...
I can't abbreviate the field; it's a free text data field and we need all of
the information for it to be meaningful - you never know if a critical bit of
data is at the beginning of the string or the last 3 words.
The field itself is imported from another source and the raw data in the
data table (not the pivot table) is all there.
Sounds like a 256 character limit and we be screwed...darn.
Thank you for your reply.