Question: Validation Rule

[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.


--

 

[Allen Browne]

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!

 

[boaz]

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.

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.

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.

 

[Allen Browne]

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.

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.

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.

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.

 

[boaz]

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.

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.

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.

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.


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.