[AccessD] code help please

Charlotte Foust cfoust at infostatsystems.com
Thu Dec 2 11:04:34 CST 2004


IsNull returns a boolean value, so it isn't necessary to make an
explicit comparison to avoid Access hangups.  I generally write long
code for readability too (in spite of my boss, who complains that I
complicate it), but since IsNull seems pretty self-evident to me, I
wouldn't bother in this case.

Charlotte Foust


-----Original Message-----
From: Erwin Craps - IT Helps [mailto:Erwin.Craps at ithelps.be] 
Sent: Wednesday, December 01, 2004 3:12 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] code help please


I would prefer

 if isnull(me.txtPONptes) = true then

I know there use to be a bug in one of the access versions with this "if
x then" without the "= y" part. They where wrongly interpreted due to
this missing operator. Some Access books advice to write the full
comparison for better readability and bla bla bla...







-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Wednesday, December 01, 2004 9:16 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] code help please

Joe

if isnull(me.txtPONptes) then


IsNull is a function.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
> Sent: 01 December 2004 07:47
> To: 'Access Developers discussion and problem solving'; 'ACCESS-L'
> Subject: [AccessD] code help please
> 
> 
> It is almost Midnight here
> What is wrong with the following code please?
> 
> Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As
> Integer)
>     if isnull me.txtPONptes then   < This is null line is the 
> trouble maker
>         Me.lblPONotes.Visible = False
>         Me.txtPONptes.Visible = False
>     End If
>     
> End Sub
> 
> JOE HECHT
> LOS ANGELES CA
>  jmhla at earthlink.net
> 
> 
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 

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



More information about the AccessD mailing list