Required Field on a Form (1 Viewer)

[StacyStacy]

Can I make a field 'required' on the form level and not thru the table level?

 

[Robert Dunstan]

Yes you can by placing some code in your form's BeforeUpdate event. For example

If IsNull(myControlName) Then

MsgBox "Please enter something!", vbCritical, "Required Entry"
myControlName.Setfocus
Cancel = True

End If

This will test for a null, however if you have set at table level 'Allow zero length strings' to yes, then you'll need to also use the Nz function

HTH
Rob

 

[rhett7660]

Re: Requied Field on a Form

How would you set it up if you have say 5 txtboxes and 3cbo boxes that you want to make sure something is filled in?

I have tried the , and the word and and I can't get it to work.


***EDIT*** I figured it out... Just use a couple more IF statements.

 

[CEH]

Re: Requied Field on a Form

Or use the "tag" property.