Using Access I have 2 different fields in a record. They cannot b.

F

Flipo

I have two different fields in a record. One or the other Must have text in
it. They cannot both be Null. How do a write validation for this?
 
B

Brendan Reynolds

If you want to do this programmatically, in the Before Update event of a
form, rather than in a table-level validation rule, it would look something
like ...

If IsNull(Me!FirstTextBox) And IsNull(Me!SecondTextBox) Then
MsgBox "Please enter a value in at least one of the text boxes."
Cancel = True
End If

If you want to do it in a table-level validation rule, it would look
something like ...

(FirstField Is Not Null) Or (SecondField Is Not Null)

To define a table-level validation rule (not to be confused with a
field-level validation rule, which can not refer to any other field in the
table) select Properties from the View menu while in table design view.
 
F

flipo

Thanks for the quick response. What am I dong wrong? I used the table level
rule entering ("Name_last" Is Not Null) Or ("Name_Nick" Is Not Null). Note
it put quotes around the field names. Also the field names use an
underscore, must I run the name together .... Namelast? Anyway, I got no
error, the record was created with both fields null.
 
F

fredg

Thanks for the quick response. What am I dong wrong? I used the table level
rule entering ("Name_last" Is Not Null) Or ("Name_Nick" Is Not Null). Note
it put quotes around the field names. Also the field names use an
underscore, must I run the name together .... Namelast? Anyway, I got no
error, the record was created with both fields null.
Click to expand...

Surround the field names with brackets!!!!!
[Name_last] Is Not Null or [Name_Nick] Is Not Null
 
F

flipo

It works! Thank you to everyone helping ... can't tell you how I appriciate
it! Sincerely, Flipo

fredg said:
Thanks for the quick response. What am I dong wrong? I used the table level
rule entering ("Name_last" Is Not Null) Or ("Name_Nick" Is Not Null). Note
it put quotes around the field names. Also the field names use an
underscore, must I run the name together .... Namelast? Anyway, I got no
error, the record was created with both fields null.
Click to expand...

Surround the field names with brackets!!!!!
[Name_last] Is Not Null or [Name_Nick] Is Not Null
Click to expand...
 
Top