Stuart McLachlan
stuart at lexacorp.com.pg
Sat Feb 1 15:43:00 CST 2003
> All documentation refers to the Is operator as used to compare two object > reference variables. But, we also use it in simple criteria expressions in > queries, etc. > > So, what Is really? > > It's a comparison operator, but why does documentation define it as a > comparison operator for objects when we obviously use it for other things? > The documentation just may be poor in implying that Is works "only with" -- > or it's very specific and there's more to it than I understand. > The only place I've ever used IS to compare anything other than objects is in Queries. There it can only be used to compare a field or expression to NULL or NOT NULL.. That is a very specific instance where you are using the syntax of Jet SQL not Access VBA. - it is the SQL version of the VBA function ISNULL(). Can you give any case where you use IS in VBA to compare anything other than objects? -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.