Do not want a footer on the first page

  • Thread starter Thread starter forest8
  • Start date Start date
F

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
 
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 :)
*
 
Back
Top