Click here to Skip to main content
14,177,045 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.190526.1 | 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