ms access - Hide report page footer -
i have developed access report made of 4 subreports. first subreport cover page report. in main report footer have added page numbers. page numbers displayed on every page of report including cover page. not want display page number (which page 1 ) on cover page. had similar problem , if me problem, thanks
there's no automatic way it. if know vba, can create function you.
you'll want textbox in page footer section. use =showpage() control source. you'll want code in module:
function showpage(optional clearpage boolean) static pagenum integer if clearpage pagenum = 0 end if if pagenum > 0 showpage = pagenum end if pagenum = pagenum + 1 end function
lastly, put 'showpage true' under report_load event. reset counter each time report run.
Comments
Post a Comment