>>>>>>Hi,
>>>>>>
>>>>>>Again, I am trying to make my app to compatible with the numeric system in Europe. I know how to change the decimal point from a period to a comma.
>>>>>>
>>>>>>But how do you change the comma separating thousands to a period? For example, so that 1,000,000.00 becomes 1.000.000,00
>>>>>>
>>>>>>I thought that the Set Separator is designed to help but cannot seem to figure how.
>>>>>>
>>>>>>TIA for any help.
>>>>>
>>>>>You must always make sure that Set Separator and Set Point are different from each other.
>>>>
>>>>I set these as follows:
>>>>set point to "," && comma
>>>>set separator to "." && period
>>>>But I when I do
>>>>? 10000000.00
>>>>The period is changed to comma; this is fine. But I don't see the 1000 separators. What am I doing wrong?
>>>
>>>You'll need to use TRANSFORM() with a picture clause to see the commas.
>>>
>>>Something like:
>>>
? LTRIM(TRANSFORM(10000000.00, "999,999,999,999.99"))
>>
>>Thank you. This adds to one more thing I need to change in the app. That is, when I display a number in the text box I would need to apply TRANSFORM().
>
>In a textbox control you can use the Format and InputMask. VFP help will give you some examples.
Yes. I entered in the Format property 99,999,999.99 and the value shows up correctly (kind of weird for an American :)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham