>Dear Ed,
>
>How about using transform function ??
>
>as:
>
>at form.init()
>
>:
>thisform.textbox.value=transform(thisform.textbox.value,"999,999,999"
>:
>
>I get the result still be in the format "999999999"
>
>What's wrong ??
TRANSFORM() returns a string, not a numeric, so if the control source is forced to be numeric, it isn't going to be a happy camper getting a string shoveled into it.
Did you try the textbox's InputMask property?