[AccessD] A2K: Stop User from oving to new record

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.






More information about the AccessD mailing list