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

Make remarks mandatory with checkbox

P: 18
Hello all,

I have a form that contains a remarks field for user input and a checkbox for out of compliance orders. I need to make the remarks field mandatory after the checkbox is checked. Right now I'm using the expression
=[Text6] Is Not Null for the validation rule but all that does is make the remarks field mandatory BEFORE you can check the checkbox.
Oct 25 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,345
The Validation Rule for the Remarks field should be :-
Is Not Null Or Not [CheckBox]

This will, however, allow an existing null Remarks field to stay null - It just won't allow you to delete the text if there is any there.
This is a limitation of the ValidationRule process itself.

Alternatively, you can check the status of it in VBA before closing the form and CANCEL it if it doesn't fit what you require.
Maybe both should be done to handle all situations.

Last thought, you could check in the AfterUpdate of the CheckBox instead.
Oct 25 '06 #2

Post your reply

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