PC Review


Reply
Thread Tools Rate Thread

Checkbox validation rule

 
 
Jon
Guest
Posts: n/a
 
      28th Oct 2007
Hello,

In form view, how do I do a very simple validation rule so that if a
checkbox is not ticked, it won't let me move on?

Thanks all,

Jon

 
Reply With Quote
 
 
 
 
tina
Guest
Posts: n/a
 
      28th Oct 2007
in the form's BeforeUpdate event procedure, add

If Me!CheckboxName = False Then
Cancel = True
Msgbox "Checkmark the box, please."
End If

replace CheckboxName with the correct name of the checkbox control, of
course.

hth


"Jon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> In form view, how do I do a very simple validation rule so that if a
> checkbox is not ticked, it won't let me move on?
>
> Thanks all,
>
> Jon
>



 
Reply With Quote
 
didi et dada
Guest
Posts: n/a
 
      2nd Nov 2007


"Jon" <(E-Mail Removed)> a écrit dans le message de groupe de discussion
: (E-Mail Removed)...
> Hello,
>
> In form view, how do I do a very simple validation rule so that if a
> checkbox is not ticked, it won't let me move on?
>
> Thanks all,
>
> Jon
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkbox Validation-to find all the checkbox are checkedor not? Priyadarshan V Microsoft C# .NET 1 3rd Jan 2009 10:55 AM
Allow enty of data outside validation rule without removing rule =?Utf-8?B?dGFzaA==?= Microsoft Access 2 7th Nov 2007 04:56 PM
Re: Checkbox Validation Rule Douglas J. Steele Microsoft Access 0 17th Nov 2005 10:26 PM
Re: Checkbox Validation Rule Douglas J Steele Microsoft Access 0 17th Nov 2005 04:23 PM
RE: Checkbox Validation Rule =?Utf-8?B?QXJ2aW4gTWV5ZXIgW01WUF0=?= Microsoft Access 0 17th Nov 2005 02:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:10 PM.