$$ always displays $ not Currency Symbol

In my grid I have a column which is bound to a numberic

I want my column to display the numberic as currency (although I want to
store it as a number)

I have set my currency up:
set currency to '£'

I set my column inputmask propery up to be "$$9,999,999" format is none, but
when run it shows a $ i.e. $12,345.67, should this not show £12,345.67 ?

I have tried other combinations of format and input mask, none of which give
me what I want
format $, inputmask 9,999,999, result: "$ 12,345.67"
format $, inputmask $$9,999,999, result: "£$12,345.67"
format $, inputmask £9,999,999, result: "£ £12,345.67"
format <none>, inputmask £9,999,999, result: "£ £12,345.67"
format <none>, inputmask $$9,999,999, result: "$12,345.67"
format <none>, inputmask $9,999,999, result: "$ 12,345.67"

How can I get it to display "£12,345.67" ????

TIA,

Fergus.

Sietse
Fri Jun 18 08:58:15 CDT 2004

Hi Fergus,

By default, the characters in the format mask are stored into the data. You
can prevent this by adding a 'R' to the format

HTH,
Sietse Wijnker

"Fergus Murray [Mason]" <fergus@mason.nospam.co.uk> wrote in message
news:OoDqNwSVEHA.3168@TK2MSFTNGP10.phx.gbl...
> In my grid I have a column which is bound to a numberic
>
> I want my column to display the numberic as currency (although I want to
> store it as a number)
>
> I have set my currency up:
> set currency to '£'
>
> I set my column inputmask propery up to be "$$9,999,999" format is none,
but
> when run it shows a $ i.e. $12,345.67, should this not show £12,345.67 ?
>
> I have tried other combinations of format and input mask, none of which
give
> me what I want
> format $, inputmask 9,999,999, result: "$ 12,345.67"
> format $, inputmask $$9,999,999, result: "£$12,345.67"
> format $, inputmask £9,999,999, result: "£ £12,345.67"
> format <none>, inputmask £9,999,999, result: "£ £12,345.67"
> format <none>, inputmask $$9,999,999, result: "$12,345.67"
> format <none>, inputmask $9,999,999, result: "$ 12,345.67"
>
> How can I get it to display "£12,345.67" ????
>
> TIA,
>
> Fergus.
>
>

Anders
Fri Jun 18 09:42:26 CDT 2004

SET CURRENCY TO '£'
SET CURRENCY LEFT
t.Format='$'
t.inputmask='9,999,999.00'
t.Value=$456.89

shows £456.89
Using VFP8, SP1
-Anders

"Fergus Murray [Mason]" <fergus@mason.nospam.co.uk> wrote in message
news:OoDqNwSVEHA.3168@TK2MSFTNGP10.phx.gbl...
> In my grid I have a column which is bound to a numberic
>
> I want my column to display the numberic as currency (although I want to
> store it as a number)
>
> I have set my currency up:
> set currency to '£'
>
> I set my column inputmask propery up to be "$$9,999,999" format is none,
but
> when run it shows a $ i.e. $12,345.67, should this not show £12,345.67 ?
>
> I have tried other combinations of format and input mask, none of which
give
> me what I want
> format $, inputmask 9,999,999, result: "$ 12,345.67"
> format $, inputmask $$9,999,999, result: "£$12,345.67"
> format $, inputmask £9,999,999, result: "£ £12,345.67"
> format <none>, inputmask £9,999,999, result: "£ £12,345.67"
> format <none>, inputmask $$9,999,999, result: "$12,345.67"
> format <none>, inputmask $9,999,999, result: "$ 12,345.67"
>
> How can I get it to display "£12,345.67" ????
>
> TIA,
>
> Fergus.
>
>