cancel
Showing results for 
Search instead for 
Did you mean: 

Memo field is truncating Crystal 2008 with Access 2003 database

Former Member
0 Kudos
77

I have a memo field on the report that is truncating the characters in the field to 255 characters. It is resizing (Can Grow is checked) and if I narrow the width the field does resize in height. I have verified the text exists in the database, but I cannot get it to show on the Crystal Report. I suspect this is an issue with Access as I have never had this issue with other data sources. Any help??

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Try verifying the database to see if the struture of the table has changed. then see if the memo field is truncated.

Former Member
0 Kudos

Hi Theresa,

1. What type of connection are you using (ODBC / OLE DB / Native)?

You can try using the Crystal Drivers for CR 2008, from the link provided below, create the DSN connection using these drivers.

https://smpdl.sap-ag.de/~sapidp/012002523100008666562008E/cr_datadirect53_win32.zip

Hope this helps you.

Regards,

Abhijeet T.

Former Member
0 Kudos

I started the install of these drivers but did not continue because my db is Access and I am not sure how to set that up (I am trying to connect dynamically to my Access DB on FTP site but have different thread open for that).

I actually found a different solution that appears to be working. I created a Command and wrote a short query to the database that pulls in only the memo field and my link to the primary table. I am now getting my complete memo field.

Former Member
0 Kudos

Hi Theresa,

In Crystal, do you see that field type as Memo ?, What is the datasource you are using ? If you have problem in pulling data into your report, check the datasource. Try to use other datasource like OLE DB etc and check.

Thanks,

Sastry