required field

[rups1]

Hi. I want to have all my fields on my form to be required and so that the user cant close the form if they are empty (error message). In the table properties I have them set to Required an have tried putting in a validation rule of IS NOT NULL but it still dont work. any help appreciated. thanks

 

[selenau837]

Hi. I want to have all my fields on my form to be required and so that the user cant close the form if they are empty (error message). In the table properties I have them set to Required an have tried putting in a validation rule of IS NOT NULL but it still dont work. any help appreciated. thanks

Use the ISNull() to check to see if null, then if it is pop a message box to let them know it is needed.

example

If IsNull(textboxname.value) Then
       msgBox("Need Info")

end If