Altering the Print Preview Layout Of a Query

[JMcQueen]

Thank goodness I've found this forum! I'm quite an new user to Access and have a problem.

I have set a command button on the switchboard which runs a macro which inturn runs a query and displays the results in print preview format. Now the amount of information displayed is too much for portrait view as it goes horizontally off the screen and on to a new sheet of paper. However in portait view its fine. So what I was wondering is is there a way of setting the default page status to landscape. I've tried altering the page setup on the table in design view but this didnt make any difference.

The reason that I did it this way is that I couldnt figure out how to get a query to display its results in 'form' form as opposed to datasheet. The datasheet view isnt very user friendly and unsuitable for my needs.

Thanks for any help given.

 

[bjackson]

in the reports design view
select file from the menu bar
select page setup

set your page and print margins,close and save the changes

 

[JMcQueen]

Its not the reports that I have the problem with, its the table. The query runs a criteria search and displays the results from the table in datasheet view. To get around this and make the results of the query a bit more presentable I used a macro to run the query and display it in print preview but the resulting information is too large for portrait.

 

[neileg]

Why are you displaying the query at all? Queries are designed to retrieve data. Forms and reports are for presenting data to users.

You can easily use the report wizard to convert your query to a report, and change your command button to show the report in print preview. This will give you full control over how it appears.

 

[JMcQueen]

I didnt know that. Having looked now its blatently obvious how to do it! I was trying to get the results of the query displayed and didnt know that I could do it using a form or report! To be honest this is the first time that I've had to use Access for anything so I'm very green as to how to do things. Its like being a 'N00b' all over again! Thanks for your patience.