VBA - Disable Access Scroll Bars

Posted on 2007-10-01
Last Modified: 2008-01-09
Can someone tell me how I would disable a vertical scroll bar in Access VBA.?

Question by:andyb7901
    LVL 13

    Accepted Solution

    FormorTextBoxName.ScrollBars = Number

    Use appropriate Number:
    Neither (forms) - 0
    None (text boxes) - 0
    Horizontal Only (forms) - 1
    Vertical Only (forms) - 2
    Vertical (text boxes) - 2
    Both (forms) -  3
    LVL 13

    Expert Comment

    note that those are hyphens and not negatives. Those are all positive numbers.

    Author Comment

    LVL 13

    Expert Comment

    glad to help...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now