Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

travelerII

Technical User
Jun 4, 2009
66
US
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?
 
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
 
Thank you for your response.

Can you give me a replace formula that might work?
 
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
 
Thank you I was able to get what I needed with your help.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top