Click here to Skip to main content
14,211,550 members
Rate this:
Please Sign up or sign in to vote.
I am using vb 6, sql server 2008 and crystal report 8.5. I have a field called Instruction whose data type nvarchar. Previously i was saving plain text data in Instruction field. But now i am saving txtRTF data in Instruction field to save instruction in local language. So now my database contains some records with instructions as plain text and some records of instruction like {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS Sans Serif;}} \viewkind4\uc1\

When i try to print this data in crystal report. Font size for plain text is different and instruction with rtf data with differnt font size. I want to same size for all records of instruction field. Even I tried to use formula for Font size but it did not work. Please help me. Thank you

What I have tried:

I tried to set font size through edit field option in crystal report. What i did like
After right click on 'instruction' Field in crystal report -> Edit field - > Under font tab, for Size , I have written formula as
If Len(Medical.Instructions}) > 1 then 9 (i.e. set size to 9)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Advertise | Privacy | Cookies | Terms of Service
Web01 | 2.8.190619.2 | Last Updated 14 Mar 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100