?
Solved

Access 2007 - how do I get vertical scroll bar on initial display of a reportview report?

Posted on 2010-11-16
5
Medium Priority
?
973 Views
Last Modified: 2012-05-10
I have a status report, that if it were in PreView mode would be one or two pages long.  In report-view it ignores page-breaks, which is what I want. However, in report-view, when longer than what can be displayed on the screen, the user cannot initially SCROLL down further to see the rest of the report - as there is no vertical elevator bar. (report scroll-bars = BOTH)

I have built in the capability to do an "F5" to "refresh" the status report, once it is displayed in report view  (as the status changes frequently), and when it refreshes (via me.requery), it DOES have the needed vertical scroll bar.

Is there a way I can make the vertical scroll bar appear on the INITIAL display of the report, WITHOUT having to force the user to hit the F5 key, to requery?  Any ideas?

0
Comment
Question by:bcreen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34148111
I'm confused.

In "Print Preview" there are No scroll bars.
And I always get scroll bars in "Report View".

Your post seems to indicate the exact opposite.

In other words, whenever I open a multi-page report in Report View, I always get vertical scroll bars...

JeffCoachman
0
 

Author Comment

by:bcreen
ID: 34149639
For some reason, when the report-view report first opens, there are NO scroll bars and no way to see anything beyond what happens to be shown on the screen.

Pressing F5 (via timer and keypress code) the report does a "requery",  redisplays, and THEN it mysteriously has the desired vertical scrollbar.

Sorry for the confusion.

Does this make any sense for AC2007 to act this way?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34151673
This may depend of your "Document Window Option" (Overlapping or Tabbed)

But in general you will get always get scroll bars in multi-page Reports opened in Report view.

You will only get scrollbars in Print preview to move "Around" the current page (If your zoom level is high), but not to scroll through the pages.

Perhaps you have some code or a setting on your report that affects this?

Can you post a sample DB that displays this phenomenon?

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Delete any objects that do not relate directly to the issue.
5. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
6. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
7. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
8. Compile the code. (From the database window, click: Debug-->Compile)
9. Run the compact/Repair utility.
10. Remove any Passwords and/or security.
11. Post explicit steps to replicate the issue.
12. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see the issue.


JeffCoachman
0
 

Author Comment

by:bcreen
ID: 34156038
HI Jeff,  GREAT 12-step program :-) to submit a problem database.  I'll hang on to that for future issues.
Unfortunately, This SQL-server based system cannot be sliced and diced and still come up with enough left over to reproduce the problem.

What I may try to do, is to automatically force the first me.requery, shortly after the report opens.  It seems that THEN the desired scroll-bar appears.

Thanks again for the detailed procedure!
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 34156378
<12-step program>
LOL.

Yes, I find it useful since "A Picture is worth a thousand words"



As far as the "Requery", goes F5 is "RefreshAll"
Try code like this on the Open, or Load event of the Report:
   
    SendKeys "{F5}"


JeffCoachman

   
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question