Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access course - intermediate access

Forum home » Delegate support and help forum » Microsoft Access Training and help » access course - Intermediate Access

access course - Intermediate Access

ResolvedVersion Standard

Yasmin has attended:
Access Introduction course
Access Intermediate course

Intermediate Access

How do you when report writing, get the data to be displayed horizontally instead of vertically?

So for example in design view I am constructing the layout of my report. When I put the field headers in place once selected from my query, they automatically are displaying the data down the page and not accross the page.

RE: Intermediate Access

Yasmin

I suggest running a form wizard and creating a report using the tabular format.
This will give you a good understanding of how to setup reports in the format you are looking for.

Essentially you need to add a "page header" area.
You can do this by clicking on VIEW, PAGE HEADER when you are in the Design view of a report. You need the field label in the page heading, and the field value in the detail section.

Hope that helps.

Richard

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.



Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.



To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.



Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.



However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.