Results 1 to 3 of 3
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011

    Vertical Scroll Bar When Using Datasheet as Subform

    I have a datasheet view form that has vertical scroll bars. When I scroll down, the column headers stay visible just like I want. When I put the same form in a header form as a subform, I lose those vertical scroll bars. All I can see is the subform scroll bar and when I use that, the column headers scroll up, off the screen. What can I do to get the vertical scroll bars to be usable in the datasheet subform? Thanks, Eddie

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    I tried to replicate your issue, can't. My datasheet subform scrolls just fine and the column headers show. If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Thanks. I have figured this out and am ashamed to admit my mistake... however, here goes. When I was testing the datasheet within the subforms, I didn't have enough rows to fill up the subform. Therefore, there was no need for scroll bars. After I added about 20 rows and the datasheet wouldn't all fit in the subform, the scroll bars appeared as normal. I did have to scroll to the very right of the subform to find it, however. Thanks again for your help. Eddie

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 08-26-2012, 11:11 PM
  2. Replies: 2
    Last Post: 05-16-2012, 10:52 AM
  3. Replies: 5
    Last Post: 04-20-2012, 10:07 AM
  4. Replies: 1
    Last Post: 08-06-2010, 07:50 PM
  5. vertical text in datasheet view?
    By johncinpcb in forum Forms
    Replies: 0
    Last Post: 06-14-2010, 07:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums