[AccessD] Code Help please

I want it to show if there is more than one page.

Joe Hecht
jmhecht at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Tuesday, January 03, 2006 2:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Code Help please

Joe,

Do you mean you only want to show the text box if the report
has
multiple pages, or you only want to show it on pages other
than page 1?
There's no point in trying to set focus to a control on a
report, so
what is it you want to accomplish with that?

Charlotte


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Joe Hecht
Sent: Tuesday, January 03, 2006 2:32 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Code Help please


I asked this once before, but I lost it when my old drive
crashed:

 

In the footer I have a text box that I want visible only if
the page count is >1

 

The property in the sheet is visible = no

 

 

I have not been able to get to get to the visible property
in code

 

Private Sub PageFooterSection_Format(Cancel As Integer,
FormatCount As
Integer)

If Me.Pages > 1 Then

    Me.txtFooterName.SetFocus

        Me.txtFooterName.v

 

End Sub

 

Please advise

 

Thanks

 

Joe Hecht

jmhecht 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