You're not really talking about an Input Mask. An Input Mask can only control
how many digits are entered. If you can enter $1,000,000 you can enter $1,123,
456 or $9,000,000! What you need to do is set up ***validation*** for the
field or control (you can it it at he table level or the form level) so that
no more than 1,000,000 can be entered. You can do this thru the Validation
Property, at table or form level, or thru code at the form level, using
validation code in the control's BeforeUpdate event..
