to give a better look to the report. The Report/Page footer bar is brought close to the fields laid out in Detail section so that the gap between records of details section is minimized. (viii) Page headers and page footers may also be added by right click at title bar of report object, followed by click at Page header/footer. .
. Refining the Report Design The design of the report created by any of the methods described above may be improved upon by making the following additions and modifications to the report. For this purpose, an existing report is opened in design mode. Adding Dates and Page Numbers : When an existing report is opened in design mode, the page footer of the report contains two unbound controls: the current date and current page number of total number of pages .
Both the controls may be customised according to the requirement of the designer. The date control uses = Now () function to retrieve the current date from RTC of computer. The format of date may be modified by selecting General date, Medium date, Short date or Long date from format property of this control. Further, when a report is created using design view method, the date and/ or time and also the page numbers may be added to any of its part.
The date and time is added by clicking Insert % date and time from the menu bar to open the Date and Time dialog box. After selecting and specifying the desired preferences regarding date and time, click OK to find that a text control with chosen date and time preferences is added at the top of active report section. This added text control containing date and time may be dragged and dropped in any part of the report as per requirement. Similarly, the page number is added by clicking Insert % page numbers from the menu bar to open the Page numbers dialogue box.
This dialogue allows the designer to specify the format, position and alignment. The two formats are: Page N (for example Page ) and