DefaultValue

[DDGonzales]

I need to set the defaultValue in VBasic for a text box
with leading zero's Example: 030901. I have tried format
(Field,00), Inputmask\000000 but when it places the data
in the table the 0 are eliminated. How can I write a code
for the defaultvalue to retain the leading 0.

 

[Sam]

Sounds like the underlying field has a number data type. You can't store
leading zeros in a number field, but you can format them with leading zeros.
If you always want six digits to display then enter 000000 as the format
property for the textbox bound to your number field.

HTH
Sam