form validation (1 Viewer)

Hi all, Can i ask how to do validation on form?

As i put the validation rule on one of my textbox = <>0
and validation text = "filed cannot be blank"

By right, if the textbox = 0 then when i click onto the save button on my form, it will prompt me the validation text right? But in my case, it did not prompt me any validation text and it save into my table

Hi Lizz, blank and zero are different things.
But you can use the Nz function to validate the input:

If Nz(me.txtbox,0) = 0 then
Msgbox "input cannot be blank or 0"
End if

MrHans said:

Hi Lizz, blank and zero are different things.
But you can use the Nz function to validate the input:

If Nz(me.txtbox,0) = 0 then
Msgbox "input cannot be blank or 0"
End if

Click to expand...

Okay, thank you!!