Arthur Fuller
artful at rogers.com
Tue Aug 3 15:54:55 CDT 2004
A la Gustav, they didn't ask me either, but I would frankly prefer these constructs: If Type(myVar) <> "Date" 'or better, <> vbaDate If Value(myVar) <> NULL If Type(myVar) <> "Numeric" 'or better, <> vbaNumeric And while we're on it, would someone kindly provide examples of the correct use of IsEmtpy()? This one has always baffled me. TIA, A. -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of bchacc at san.rr.com Sent: Tuesday, August 03, 2004 4:31 PM To: dba-tech at databaseadvisors.com Subject: RE: [dba-Tech] On Odious Code I use Not Isull an Not IsDate and Not IsNumeric. Same thing? Rocky