Do not want a footer on the first page

[forest8]

Hi there

I put a footer in a form which when it prints runs on to two pages. I don't
want the footer on the first page only the second.

How do I fix this?

Thanks

 

[Crystal (strive4peace)]

Hi Forest,

not sure about a form ... on a report, it is easy
~~~
In code, it is on page 1, make the report footer not
visible, otherwise, make it visible.

if you want to reference [Page] or [Pages] in code, put
calculated controls on your report and compare them instead
of the variables... for instance:

Name --> PageNo
ControlSource --> =Page

Name --> NumPages
ControlSource --> =Pages
(you don't need this one)

once these controls are on the report (they can be hidden),
you can get the values in code

now, put this code in the report footer event:

'~~~~~~~~~~~~~~~~~
If PageNo = 1 then
me.Footer_sectionname.visible = false
else
me.Footer_sectionname.visible = true
end if
'~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal
remote programming and training

http://MSAccessGurus.com

My Analyzer
.... the ultimate Data Dictionary Tool
by Crystal
http://www.AccessMVP.com/strive4peace/Dictionary

*
have an awesome day
*

 

[Crystal (strive4peace)]

Hi Ken,

thanks for simplifying that <smile> ... and another reason
to use a report

*
have an awesome day
*

Warm Regards,
Crystal

My Analyzer
.... the ultimate Data Dictionary Tool
by Crystal
http://www.AccessMVP.com/strive4peace/Dictionary