[AccessD] Dirty property

[Steve Schapel]

Yes, I know.  ;-)

Regards
Steve

-----Original Message----- 
From: Gustav Brock
Sent: Friday, July 24, 2015 9:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Dirty property

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com