Force Default Value

[fenhow]

Hi, I have a form with several currency bound fields.
The users can delete the default value of $0.00 but I do not want that form to have null, is there a way I can always have $0.00 in that field if the user leaves it as null?
Fen

 

[pbaldy]

You can force a value in a control's after update event:

Me.Textbox = Nz(Me.Textbox, 0)

 

[fenhow]

Perfect of course! Thank you sir.
Fen

 

[pbaldy]

Happy to help! I actually use a little function that also gets rid of extra digits. I found people were fat-fingering and adding a digit at the end once in a while (12.345 instead of 12.34).