change report view to suit my screen size

[Davros]

hi
firstly is it me or has the search facility on this fantastic website been changed? everytime i do a search i now almost always get 500 records which is far to many records to sort through to find a solution for a specific problem.

anyway my simple problem is this:
one of my reports shows in report view [acviewreport] (it must show in report view and not print preview). i need to decrease the size of the report so it fits on my screen. how the hell do you do it? yes i can do it in print preview but it seems to default to a particular size in report view. something so simple yet i am really having a hell of a job finding a solution for this problem.
any ideas??

thanks in advance

 

[vbaInet]

Report View is as is - it cannot be changed in size. You can set the Pop-Up property of the report to Yes which will allow you to change the size of the report object, but the data will still be spread across the entire window.

 

[Davros]

what a pain.
i have an A3 report which you have to scroll through, both up-down and across, just to view the whole record. yet in print preview you can see the whole record??
seems a strange design problem.
is there anyway i can put and active a command button on a report that opens up in a print preview?

thanks for the quick answer

 

[vbaInet]

what a pain.
i have an A3 report which you have to scroll through, both up-down and across, just to view the whole record. yet in print preview you can see the whole record??
seems a strange design problem.

Not sure what you mean here. In Report View you see all records from the record source, although it may require you to scroll up/down and or left/right, whilst in Print Preview you would need to move between Pages using the Navigation Bar. Maybe you want to look at the Page Setup of the report.

is there anyway i can put and active a command button on a report that opens up in a print preview?

Set the Default View of the report to Print Preview, but I thought you initially wanted Report View?

 

[Davros]

each record has 10 fields associated with it in a horizontal design. these 10 fields in report view will not fit on the screen hence the scrolling. in print preview you have a zoom option so i can fit the whole record onto my screen and still read it. this is what i'm going on about.
you cannot, as far as i know, put an acitve command button on a report that can be activated in print preview. if you could this would solve my problem. i ahve 5 other reports running all in print preview and all of them work fine when viewing them. this is the only report i need in report view becasue i need an active command button on it.
any other suggestions?

 

[vbaInet]

Yep, that's the main feature of Report View - it can react (or listen) to events.

Maybe you want to consider a form instead if you need a button on there.

Let me have a look at your db.

 

[Davros]

the person i'm doing it for does like the form i designed and as he's on a higher pay grade.
have you tried explaining access to someone who does not understand it yet wants their own way?
oh well - he will just have to scroll through it