Jeffery,

The only problem with this solution is that when the user enters 123,456,789.01 the dollar sign vanishes.

If the data field where the data is stored is sized n(12,2) this is OK. If the data field is sized n(11,2) because the dollar sign is expected to be a format-mask character, the data will be truncated when saved to the table.

Just be sure to make the field that holds this data big enough and realize that the dollar sign vanishes when that size is reached.

JohnG...


>>Can someone tell me how I can make sure that my input boxes are in the folloiwng format: $9,999.99? When I place the format and the input mask as this, the field is not populating properly...
>
>
>Jeffrey,
>
>Does this help ?
>
>(in the Properties box)
>
>Format = K$ (K plus Dollar sign)
>Inputmask = 999,999,999.99
>Value = $0 (if not bound to a field)