> >
> > ******************************************************************************************
> > ******************************************************************************************
> >
> > Now we're on the same page. I'm glad. Field DMI is a character column and it should record something like " = 19 and = 32". I need to have this whole string in the field dmi. If I can't get this to work, then I may have to tell them to use " <= 19 and >= 32" instead. I do agree with you that we can't have 2 fonts for the same field because then it won't make any sense. I can use FoxFont to store the "Less than or Equal to" and "Greater than or Equal to" signs in the table and show them on the GUI. But I can't get them to show on the report. My guess for the table that didn't store the "Greater than or Equal to" symbol right would be that the table already had some superscript characters in it. It worked just fine when I created a new table. This might be a gitch for MVFP. I don't know how to convert from foxfont in the table to symbol on the report using chrtran(). I'm about to give up because I have no solutions for this. I have been searched and I can't find another font that has both of those symbols. Thanks.
> >
> > Tai Nguyen.
>
> Tai,
>
> dont give up, you are almost there, just understand a few things.
> 1. you can't use 2 different fonts in one textbox
> 2. you can't for the same reason concentate two different fields with different fonts to one field/variable without seeing glibiss if the charactes are different in the two fonts.
> In your case you are a lucky guy since chr(48) till chr(57) will give you, like in most other fonts 0 - 9
> So the only thing you have to do, no chrtran or whatever fancy transforming in your report, set the font on that particular textbox to "Symbols" and you are done.
>
> Try in the command window
>
>
>

> clea
> FOR n = 48 TO 58
> ?? CHR(163)+CHR(n)+'- ' font "Tahoma"
> next
> ?
> FOR n = 48 TO 57
> ?? CHR(163)+CHR(n)+'- '  font "Symbol"
> next
> 

>
> you will see your famous GreaterThanAndEqualsTo plus a number in the last row = (symbol font) Britsih Currency + Symbol in first row (Tahoma)
>
> Alternatively but than you are restricted to 2 to 4 decimal digits to transform the figure to currency aplying your GreaterThanAndEqualsTo as a currency, making a logic to show LesserThanAndEqualsTo currency if needed. This way you dont have to store the chr(163) in your table only a logic. Doubtfull if the guy after this will be happy when he sees that coding. But it should work. Try the first solution first.
>
> Remember anything can be done in FoxPro, what ever. You would like to have a by you selected one colored gradient picture in FoxPro no problem. You want special characters ? Can be done.
>
> Regards,
>
> Koen

*************************************************************************************
*************************************************************************************

Hi Koen,

First of all, I want to say "Thanks" to you for your encouragement and all. I will keep thinking why the table itself won't accept the "superscript 3" character. Most of our tables work just fine but some are not. What could it cause this "³" to change to this "3" in the table? I already tried with font Tahoma but still though, the font stored this "3" in the table anyway and instead of this "³". If I could fix the table somehow then no matter what font I use, everything should work and it's done. The table I want to insert the "Greater than or Equal to" sign is having an conflict somehow you know. I got the "Less than or Equal to" sign worked just fine because it stored the "pound" sign in the table fine (this is a pound sign "£" ). I don't know what to do than to think harder and harder. Also in hoping God will send an angel to me, maybe you're my angel, hehehe. I know how it feels when I'm almost there.

Tai Nguyen.