I have a MaskEdit control on my form with the following properties:
- Format = "0"
- Mask = "###"

When assigning a value from code, I get all kinds of problems if rsContracts!Term < 100. With rsContracts!Term >= 100, I have no problem. Here what I've tried:
1. MaskEdit.Text = rsContrats!Term => Error

2. MaskEdit.Format = ""
MaskEdit.Mask = ""
MaskEdit.Text = rsContrats!Term
MaskEdit.Format = "0"
MaskEdit.Mask = "###" => Blank value

3. MaskEdit.Text = Format(rsContrats!Term, "###") => Error

4. MaskEdit.Text = Format(rsContrats!Term, "000") => Extra zero at the left (10 show up as 010)

I'm short of ideas, so if someone have some, I would be pleased to hear them.

TIA