[AccessD] code help please

Erwin Craps - IT Helps Erwin.Craps at ithelps.be
Wed Dec 1 05:11:37 CST 2004


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



More information about the AccessD mailing list