[AccessD] code help please

Karen
I'm thinking that its label will be though, so while making the text box
invisible may be a bit unnecessary the IsNull test itself is still valid.

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

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Nicholson, Karen
> Sent: 02 December 2004 17:34
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] code help please
> 
> 
> Which still begs the question, if it is null, it will not be visible.
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Charlotte Foust
> Sent: Thursday, December 02, 2004 12:05 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] code help please
> 
> 
> 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
> -- 
> _______________________________________________
> 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
> 
>