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

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -