Pass 11 0's in a empty field automatically

[Guest_imported]

What i need is when the user don't insert nothing in a field automatically this field put 11 0's. How can i do it?

Tkx

;-)

 

[MichaelRed]

String(11, "0&quot
MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[JoeMiller]

MyResult = IIf(IsNull(MyControlName)=TRUE,"00000000000",[MyControlName])

Joe Miller
joe.miller@flotech.net

 

[Guest_imported]

Sorry, but i don't understand. Where i put de code to do it

Tkx

 

[mac318]

Right click on text box, select properties, and place Joe's code in the control source as follows:
= IIf(IsNull(MyControlName)=TRUE,"00000000000",[MyControlName])


Begin with the equals sign.

mac318