Stuart McLachlan
stuart at lexacorp.com.pg
Mon Apr 5 16:51:00 CDT 2004
On 5 Apr 2004 at 11:19, Heenan, Lambert wrote: > > BTW here's a way to check for nulls and empty string in one step, and it's a > tad easier to read (IMHO). > > Instead of ... > > If IsNull(Me.cmbOffence) Or Me.cmbOffence = "" Then > > use... > > If cmbOffence & "" = "" Then > Or: If NZ(cmbOffence,"") = "" Then or even just NZ(cmbOffence) since "" is the default for NZ(string) -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.