Make remarks mandatory with checkbox

[danibecr]

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.

[NeoPa]

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.