only 255 characters showing in CR XI for Access Memo field

[Renasant]

I have several MEMO fields in my access database that are being truncated at 255 characters in Crystal reports. These are very long fields with data typed by users. We use them as reports to managment to show progress in problem loan resolution.

Field Explorer shows them as Memo fields. Can grow is true. Maximum lines is set to 0. Text interpretation is none. CSS Class Name is blank.

Why won't Crystal show the full text of these fields?

 

[Renasant]

Bug Found in CR
under "Report Options" uncheck "select distint records" and the whole memo field will display. No other changes made just unchecked this totally unrelated option for the report and CR displays the entire memo field.