>Hi everybody,
>
>I have two fields in a table, MtgLow and MtgHigh. Both of them are numeric 9. I want to provide a user input with this format $999,999,999. I tried several combinations in format vs. InputMask property, but all of them don't get me desired result. Could you please tell me, how should I set them up?
>
>Thanks in advance.
Put $ in the Format property and " 999,999,999" in the input mask. I added the extra 9, because you will need it to display the $ sign. Finally the control source of the textbox needs to be bound to a numeric or currency source.
Mark McCasland
Midlothian, TX USA