Can't change size of characters in memo field, remains illegible 1

[travelerII]

I am using Crystal Reports 10.
I have a table called TEXCLOB. Within it is a memo field called TEXTE_0.I don't really understand how that works as the memo field doesn't show in the TEXCLOB table when I am linking it to other tables but it does show up in the TEXCLOB table in field explorer.
I can add it to the details section but the printing is illegible and I can't change it. Under the field formatting there is a text interpetation drop down menu and using RTF text allows it to be printed out legibly however extremely tiny and I really need it to be legible within the report.

Any thoughts on how I can do this?

 

[IanWaterman]

AS it is stored as RTF that is how it will be.

Crystal can not vary font of a RTF interpreted field.

You can try and be clever and use Replace() in a formula to replace the RTF tag which determines font size and make it bigger.

However, I think CR10 can only handle memo fields up to 4000 chars.

Ian

 

[travelerII]

Thank you for your response.

Can you give me a replace formula that might work?

 

[IanWaterman]

You will need to copy sample to notepade and try to find the tag which controls font size.

I not sure but its something like

\fs24\

This represeents font size 12

formula will be like this

Replace({yourmemofield}, 'fs\24', '\fs12\')

This would reduce font from 12 to 6.

Ian

 

[travelerII]

Thank you I was able to get what I needed with your help.