By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,772 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Validation Rule

P: 33
Hi,

I am trying to set a simple validation rule so that when my form is being filled out it the fields cannot be blank. I am somewhat knew to writing expressions and stuff so any assistance woul dbe greatly appreciated.

Thank you in advance
Jul 24 '07 #1
Share this Question
Share on Google+
5 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi,

I am trying to set a simple validation rule so that when my form is being filled out it the fields cannot be blank. I am somewhat knew to writing expressions and stuff so any assistance woul dbe greatly appreciated.

Thank you in advance
Hi.

You can make it on table level setting a corresponding table field "Required" property to "Yes".
Jul 24 '07 #2

P: 33
Hi.

You can make it on table level setting a corresponding table field "Required" property to "Yes".

Hi, Thanks for the response. I have done that already but it never worked. my situation is that I have data already entered and I need it so that when others are filling out the form I created they cannot move on to the next field if it is blank. I changed the "Required" property to yes already with no other changes. Am I missing something or do I need to do anything else?

Thanks
Jul 24 '07 #3

FishVal
Expert 2.5K+
P: 2,653
Hi, Thanks for the response. I have done that already but it never worked. my situation is that I have data already entered and I need it so that when others are filling out the form I created they cannot move on to the next field if it is blank. I changed the "Required" property to yes already with no other changes. Am I missing something or do I need to do anything else?

Thanks
Ok. The following code in Exit event handler for form control Text4 will avoid moving to another field as long as Text4 is empty. It will however allow to move focus to another form.
Expand|Select|Wrap|Line Numbers
  1. Private Sub Text4_Exit(Cancel As Integer)
  2.     If IsNull(Me.Text4) Then Cancel = True
  3. End Sub
  4.  
Jul 24 '07 #4

P: 33
Thank you I got it to work. Thanks for your help.
Jul 24 '07 #5

FishVal
Expert 2.5K+
P: 2,653
Thank you I got it to work. Thanks for your help.
Glad it was helpful.
Jul 24 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.