Thought I'd post this extremely simple solution as I wasn't able to easily find it elsewhere. Solution thanks to thealy via BigResouce.com.
Issue:
Memo type table fields (or query generated strings) in excess of 255 characters are complete in Access but are truncated when exported to text file...