> >
> > 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 "³".
I am greatly puzzled about 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.
Again puzzled, this is the 1st time I hear something like that maybe your table is indeed completely messed up, so retry with a new fresh table and if that works get rid of the old broken oneI 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.
Tai,
You are definitely on the wrong (thinking) line.
read also my
remarks in your message
A table can contain any kind of character you like. What you see is not the content of a table but a converted integer to an image. This image resembles a character or even a smaal picture if you like. The logic and code to convert the integer to an image is done in the Font file.
Now this definitely very very quickly told, but I believe basicly correct.
If you change the font in your display logic you will get an other picture.
So if you see a British Pound sign in your field where you have inserted chr(163) you have not assigned the font Symbol to that field, but an other.
Now if you understand that and you can see your famous Greater e.s.o. sign on your screen in your textbox whatever, than go to your report select that particular text box again and assign the Symbol font to that box (you know how to do that?) Now run your report and tell me the result. If still not statisfied I request you to zip me:
a. your table with no more than 3 rows and b. your report
This MUST and SHALL be solved!
regards,
Koen
P.S. how did my example programm work out on yoyr screen?