How can I make a text box = 0 if it is left blank?

[Blitz]

I have a text box that If it is left blank I want it to automatically put a 0 in the box. How can I do this?

 

[Eradic8or]

Make its default value "0"

eradic8or

 

[Eradic8or]

Or ou could type this code in the lostfocus event.

If textbox.value = "" then
textbox.value = "0"
Else
End if

 

[Guest_imported]

I'm not sure if the question you asked has been answered. Do you want the default value of the box to be zero or do you just want a zero to show up in the box?

 

[rhicks]

You could also use the Before Update of the form to check the value of your textbox, if it is null then set the value to 0. This event only fires if the record is dirty, so you can close the form without the event firing if the record has not be created.

HTH
RDH

Ricky Hicks
rdhicks@mindspring.com

 

[Blitz]

Thanks for the help, what I ended up doing was changing the validation to "Is Not Null" that way if it is left blank it gives a message saying a value must be entered.