[AccessD] code help please

I think what was happening is that the field is on the report and it is
not set to grow and shrink, or the section it is in is not growing or
shrinking.  Or, I think the question would have been regarding the label
control and not the text field.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Thursday, December 02, 2004 12:55 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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
> 
> 

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