Adding Objects to the Report
When you return to the Properties window for the Report object, you will see the SQL details in the Record Source field.
Now that you have identified which table or tables to select data from, objects need to be added from the table(s) to the report.
Access provides a very nice feature that allows you to easily select which objects you would like to appear on your report. In the ribbon at the top of the page, click on the Design tab and then on the button called ‘Add Existing Fields’.
A small window will appear based on the Record Source selected earlier:
All of the fields that are available for use will be listed.
To select one of these fields to be added to your report, highlight the object in the window, and then drag it to the location in the report where you would like this object to appear.
In the example below, four objects were chosen and added to the detail section of the report.
You will probably need to resize the object. To resize, click on the object that you wish to resize. You will notice small boxes around the perimeter of the object like in the example below.
Move your mouse pointer over one of these "resizing boxes". When your mouse pointer displays a double-headed arrow, hold down the left mouse button and drag the object to the desired size.
You also have the option to move an object. To do this, move your mouse pointer until it displays a hand icon. Then hold down the left mouse button and drag the object to the desired location.
You may also want to resize your detail section. To do this, move your mouse pointer over the bottom of the detail section until your pointer displays a double-headed arrow, then hold down the left mouse button and drag until the detail section is the desired size. The example below shows the results of resizing the objects and the detail section of the report.
By Admin at 13 Dec 2016, 17:11 PM