String field not printing on Crystal Report

[melflynn]

My Crystal Report (v9) is linked to an MS Access database query via ODBC. One field is a memo field that has been trimmed in the query so it will appear as a string field. However, in my report the field is showing up as a string field of 0 length. Can anyone suggest a solutionto this?

Rgs,

 

[AndrewBaines]

Trim to 253 rather than 255. I think back in the dark days of Crystal 9, that a null was added - that takes you to 254, then its one less for luck.

Andrew Baines

http://www.pursuittechnology.co.uk