If just in an object on a form then put in .Valid or .LostFocus event. If it is a textbox class can put in an _Assign method. Then you can drop that box on any form you want this desired result.
This.Value=ALLTRIM(TRANSFORM(VAL(This.Value),"###,###"))
Play with the command to get the exact desired result.
Aloha,
James
>Hi
>
>I have a text box with inputmask='99,999' I want the comma only if the amount is > 1000
>
>thanx