Question: Validation Rule

  • Thread starter Thread starter boaz
  • Start date Start date
B

boaz

Hi,

I've seen the following in a field's Validation Rule property. I don't know
what this is. Would you give me some pointers please?

"Conditional" Is Not Null

This is the exact content in the Validation Rule property of a field.
What is "Conditional" (with the qoutations) meant to do with Is Not Null?

This field is not a key field and is not required (Required = No).
Allow Zero Length is also set to No.


--
 
If you had a field named "Conditional", you might use a Validation Rule of:
[Conditional] Is Not Null
That would have the same effect as setting its Required property to True,
since Not Null means it's not allowed to be left blank.

As it stands though, the rule is useless: The string value "Conditional"
will always be just those 11 letters, so it will never be blank!
 
Hi,

The value IN THE "Validation Rule" PROPERTY is:

---> "Conditional" Is Not Null <----

With the word Conditional and THE QUOTATION MARKS.

Quotation Mark + Conditional + Quotation Mark + Is Not Null

I thought "Conditional" is a reserved word or build in function or something
like that because Access doesn't display any error message.

But I just don't know what this "Validation Rule" does.




Allen Browne said:
If you had a field named "Conditional", you might use a Validation Rule of:
[Conditional] Is Not Null
That would have the same effect as setting its Required property to True,
since Not Null means it's not allowed to be left blank.

As it stands though, the rule is useless: The string value "Conditional"
will always be just those 11 letters, so it will never be blank!

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


boaz said:
Hi,

I've seen the following in a field's Validation Rule property. I don't know
what this is. Would you give me some pointers please?

"Conditional" Is Not Null

This is the exact content in the Validation Rule property of a field.
What is "Conditional" (with the qoutations) meant to do with Is Not Null?

This field is not a key field and is not required (Required = No).
Allow Zero Length is also set to No.
Click to expand...
Click to expand...
 
No. Conditional has no special meaning in that context.

The validation rule does absolutely nothing except to slow things down
slightly every time you save a record into this table, while Access checks
to see if the literal string "Conditional" is Null (which it never can be).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


boaz said:
Hi,

The value IN THE "Validation Rule" PROPERTY is:

---> "Conditional" Is Not Null <----

With the word Conditional and THE QUOTATION MARKS.

Quotation Mark + Conditional + Quotation Mark + Is Not Null

I thought "Conditional" is a reserved word or build in function or something
like that because Access doesn't display any error message.

But I just don't know what this "Validation Rule" does.




Allen Browne said:
If you had a field named "Conditional", you might use a Validation Rule of:
[Conditional] Is Not Null
That would have the same effect as setting its Required property to True,
since Not Null means it's not allowed to be left blank.

As it stands though, the rule is useless: The string value "Conditional"
will always be just those 11 letters, so it will never be blank!

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


boaz said:
Hi,

I've seen the following in a field's Validation Rule property. I don't know
what this is. Would you give me some pointers please?

"Conditional" Is Not Null

This is the exact content in the Validation Rule property of a field.
What is "Conditional" (with the qoutations) meant to do with Is Not Null?

This field is not a key field and is not required (Required = No).
Allow Zero Length is also set to No.


--
There is no answer.
There has not been an answer.
There will not be an answer.
That IS the answer!
And I am screwed. Deadline is due tomorrow.
Click to expand...
Click to expand...
Click to expand...
 
Ah!!! I see.

So "something" Is Not Null will be always TRUE.

<G!> Who put this stupid thing in that box???!!!

Thanks for your help.

Allen Browne said:
No. Conditional has no special meaning in that context.

The validation rule does absolutely nothing except to slow things down
slightly every time you save a record into this table, while Access checks
to see if the literal string "Conditional" is Null (which it never can be).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


boaz said:
Hi,

The value IN THE "Validation Rule" PROPERTY is:

---> "Conditional" Is Not Null <----

With the word Conditional and THE QUOTATION MARKS.

Quotation Mark + Conditional + Quotation Mark + Is Not Null

I thought "Conditional" is a reserved word or build in function or something
like that because Access doesn't display any error message.

But I just don't know what this "Validation Rule" does.




Allen Browne said:
If you had a field named "Conditional", you might use a Validation
Click to expand...
Rule
of:
[Conditional] Is Not Null
That would have the same effect as setting its Required property to True,
since Not Null means it's not allowed to be left blank.

As it stands though, the rule is useless: The string value "Conditional"
will always be just those 11 letters, so it will never be blank!

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Hi,

I've seen the following in a field's Validation Rule property. I don't
know
what this is. Would you give me some pointers please?

"Conditional" Is Not Null

This is the exact content in the Validation Rule property of a field.
What is "Conditional" (with the qoutations) meant to do with Is Not Null?

This field is not a key field and is not required (Required = No).
Allow Zero Length is also set to No.


--
There is no answer.
There has not been an answer.
There will not be an answer.
That IS the answer!
And I am screwed. Deadline is due tomorrow.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top