Freeze top row in a report access 2013

[Bassem]

Hello,

Is there a way to freeze the headers in a report so that when you scroll down it still shows?

Thanks

 

[Joe4]

Are your headers in the Detail section of the Report, or the Report Header or Page Header section?
I recommend putting them in one of the Header sections.

 

[Bassem]

They're in the page header.

In the print preview they show on top of each page, I was just wondering if there is something in access similar to freeze top row in excel.

For Tables and Queries this automatically happens, the header of each column still shows when you scroll down. Wondering if you can have that when viewing a report (without it being divided into pages).

If I want managers to access only reports, I would like them to be able to view it a bit similar to excel with the top row freezed.

Thanks for your help

 

[Joe4]

Access doesn't really work that way. Think of Access Reports as printed sheets of paper or PDFs. You can size them so you see a full page on a screen (in which case, it should be fine since the headers are on each page). However, if you have it zoomed or sized differently, the Page Header may not be visible.

You can do something like that with Forms, if you have Form headers on Continuous Forms.

 

[Bassem]

Its good to know.

Thanks for your help Joe.