[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