Results 1 to 12 of 12
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095

    Can't get "Vertical Only" to show on form

    Below are the Format properties for a form I have where I need the vertical scroll bar. I open the form thus: DoCmd.OpenForm "frmSettings", , , , , acDialog

    Click image for larger version. 

Name:	000.jpg 
Views:	20 
Size:	114.7 KB 
ID:	52147



    I temporarily negated the OnLoad code to see if that made a difference, but the vertical bar still fails to appear. (The OnLoad is the only Event for this form)
    Anything obvious this Old Geezer just doesn't see
    Attached Thumbnails Attached Thumbnails 000.jpg  

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Are there other drives not shown? If those are all the drives, the gray bar may be the scroll bar.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    I don't know where that picture came from? I only downloaded the screenshot of the Format Properties. If I edit the OP it does not show.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    If you go into the advanced area, 2 attachments show with the same name.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,930
    Vertical scrollbar will only show if it is needed - so would be better to show a screenshot of the form to illustrate your issue

  6. #6
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    On my desktop with large monitor I get the full form. On a laptop the form is essentially truncated at the blue line.
    Click image for larger version. 

Name:	001.jpg 
Views:	15 
Size:	140.1 KB 
ID:	52149

  7. #7
    Micron is online now Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Well, just for S's and G's I'd see what happens if it's not opened as acDialog...
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  8. #8
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    DoCmd.OpenForm "frmSettings" ', , , , , acDialog

    Good guess! Form opens on laptop with vertical scroll bar enabled, suppressed on desktop where not needed. Not sure if any other arguments with OpenForm would also have an affect were the acDialog were to remain.

  9. #9
    Micron is online now Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    So you're saying acDialog was the issue?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  10. #10
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    Yes, it seems so. As you can see, all I did was comment out the argument string, compile and go.

    Thanks for the good guess

  11. #11
    Micron is online now Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Glad I could help, even if in some small way. I think I will reward myself with a Moosehead.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  12. #12
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,930
    I suspect it is to do with form height- if it is taller than the monitor it will just disappear off the bottom of the screen

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

Similar Threads

  1. Replies: 4
    Last Post: 04-24-2021, 02:04 PM
  2. Replies: 4
    Last Post: 07-15-2016, 03:59 PM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. "Decrease Vertical" grayed out on form
    By kelann in forum Forms
    Replies: 7
    Last Post: 10-26-2012, 01:43 PM
  5. "transposing vertical data into horizontal columns"
    By stevelondon in forum Queries
    Replies: 3
    Last Post: 03-20-2012, 12:36 PM

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