[AccessD] Code Help please

In that case, try checking for Pages > 1 in the ReportHeader_Format and
set the visibility of the control from there.

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:51 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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