G
Guest
On a form with 20 or so fields there is a group of 5 fields that must ALL be
null, or, must ALL be not null. How can I enforce this?
TIA
null, or, must ALL be not null. How can I enforce this?
TIA
M
[MVP] S.Clark
Short Answer: With VBA code
Long Answer: In the code, you have to check to see the state of one of them.
Blank / Not Blank. Then step through the other 4 to find one that is the
opposite. React accordingly.
Long Answer: In the code, you have to check to see the state of one of them.
Blank / Not Blank. Then step through the other 4 to find one that is the
opposite. React accordingly.
S
Sergey Poberezovskiy
Just put some validation code into Form_BeforeUpdate event
to perform your checks, and assign Cancel to True if
controls on the form did not pass the validation.
HTH
to perform your checks, and assign Cancel to True if
controls on the form did not pass the validation.
HTH
B
Brendan Reynolds
You could do this with a table-level validation rule, though it's not
pretty. To create a table-level validation rule, open the table in design
view, and choose Properties from the View menu. Type your validation rule in
the Validation Rule row in the Table Properties dialog, and the message you
want to display to the user when they attempt to save a record that would
violate the rule in the Validation Text row. Here's an example using two
fields (because I'm too lazy to type one using five!
([Test1] Is Null And [Test2] Is Null) Or ([Test1] Is Not Null And [Test2] Is
Not Null)
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
pretty. To create a table-level validation rule, open the table in design
view, and choose Properties from the View menu. Type your validation rule in
the Validation Rule row in the Table Properties dialog, and the message you
want to display to the user when they attempt to save a record that would
violate the rule in the Validation Text row. Here's an example using two
fields (because I'm too lazy to type one using five!
([Test1] Is Null And [Test2] Is Null) Or ([Test1] Is Not Null And [Test2] Is
Not Null)
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.