I want to do something that MUST be supported by VFP, but I'm flummoxed as to how to get it exactly as I want it.

I have a textbox which is used to enter dollar amounts (11.2 field will hold the data). I want to allow the user to enter 8 digits to the left of the decimal point, and 2 to the right, and I want commas and a currency symbol inserted at the proper places.

The InputMask for this field is set to: '$$,999,999.99'; this does everything I want EXCEPT whent he user enters 8-digit values (e.g., 12,345,678.90), when the dollar sign is lost.

The problem seems to be that the $$ in the input mask take the place of 2 digit places, but ALSO specify the floating currency symbol.

I suspect this is a stupid question, but...

Help!

-- jas