With SET SYSFORMATS ON most of this is set up in the control panels regional settings. Then on the object use the following values.

Form.TextBox.Format = "$"
Form.TextBox.InputMask = "9 999 999.99"

This will get you the correct format.

Good Luck