>>>>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.
>>
>>This didn't work.
>
>Something else is going on then because it works for me. But I see you got an alternate solution.
If showed correctly the first time, however, when I typed something and moved to another field, it didn't show correctly anymore. Don't know, why is that, but the alternative solution worked.
If it's not broken, fix it until it is.
My Blog