Pass 11 0's in a empty field automatically

Guest_imported · Aug 20, 2001

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 · Aug 20, 2001

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 · Aug 20, 2001

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

Joe Miller
joe.miller@flotech.net

Guest_imported · Aug 20, 2001

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

Tkx

mac318 · Aug 20, 2001

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Pass 11 0's in a empty field automatically

Guest_imported

New member

MichaelRed

Programmer

JoeMiller

IS-IT--Management

Guest_imported

New member

mac318

Programmer

Similar threads

Part and Inventory Search

Sponsor