Solved VBA to check for Null values in certain fields in a form

[Nagesh]

Hi,
Some fields in a form needs to be checked for null entries.
Is there function to determine whether the field is null and 'set focus' to that particular field and also exit code?

I use the below code and repeating the same for each field to check the null value;

' Check for null entries
If IsNull(Fname) Or Fname = "" Then
    MsgBox "Please fill in your First Name !!"
    Fname.SetFocus
Exit Sub
End If

It would be great if we can use a VB function for this.

 

[bob fitz]

I would suggest some code in the forms Before Update event (which can be used to stop the form from updating if the validation fails) to loop through all the required controls and test for a value. If no value is found, cancel the update and set the focus to the control with no value and present the user with a message.

 

[bob fitz]

Another thought. You could just set each fields' "Required" property to "Yes" at the table level.

 

[jdraw]

I agree with Bob --use the BeforeUpdate event of the form for your validation checking. That is the last event before the form is saved. You may also involve the Tag property of the controls on the form to be checked.

 

[arnelgp]

there is similar discussion here and i posted an alternative solution.
same thing, add "Tag" to your control. i used "Required" as tag.
see post #10 on this thread for the sample.

Solved - Check that fields contain values..

This might be an old thing for all of you.. I have my form and all is working, some records on my table (fname, lname, etc, and some combo boxes generated from a query on the database) MUST have something, and by using on the table the option of (THIS RECORD MUST NOT BE EMPTY [OR REQUIRED =...

www.access-programmers.co.uk

 

[vhung]

Hi,
Some fields in a form needs to be checked for null entries.
Is there function to determine whether the field is null and 'set focus' to that particular field and also exit code?

I use the below code and repeating the same for each field to check the null value;

' Check for null entries
If IsNull(Fname) Or Fname = "" Then
    MsgBox "Please fill in your First Name !!"
    Fname.SetFocus
Exit Sub
End If

It would be great if we can use a VB function for this.

yeah;
>you may use function
>maybe you should try to use:
Select Case "whether the field is null and 'set focus"
then Time Interval for Requery; or maybe to OnLoad Form Event...

 

[Nagesh]

there is similar discussion here and i posted an alternative solution.
same thing, add "Tag" to your control. i used "Required" as tag.
see post #10 on this thread for the sample.

Solved - Check that fields contain values..

This might be an old thing for all of you.. I have my form and all is working, some records on my table (fname, lname, etc, and some combo boxes generated from a query on the database) MUST have something, and by using on the table the option of (THIS RECORD MUST NOT BE EMPTY [OR REQUIRED =...

www.access-programmers.co.uk

Thanks arnelgp,
This is exactly what I was looking for !!