[AccessD] Dirty property

Gustav Brock gustav at cactus.dk
Fri Jul 24 04:53:54 CDT 2015


Hi Steve

Oh, missed that completely, sorry.

I checked out the field validation (didn't work) but I missed the table validation. Never used that for anything.
But it works! The syntax is:

    Not IsNull([SomeField]) Or Not IsNull([AnotherField])

That works also when the table is linked.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Steve Schapel
Sendt: 24. juli 2015 11:26
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Dirty property

Oh Gustav, I fear it is you who have failed to read mine, and not the other way around!  :-)

I most certainly did read what you wrote, and my reply was directly thereto.

It looks like you were trying to enter:
    Is Not Null Or [OtherField] Is Not Null as a field-level validation rule, not a table-level validation rule.  This is different from my suggestion of:
    [SomeField] Is Not Null Or [AnotherField] Is Not Null as a table-level validation rule.

Forgive me if I have misunderstood.

Regards
Steve 



More information about the AccessD mailing list