What defines the minimum width of an Access form?

Posted on 2011-05-05
Last Modified: 2012-06-27
Dear Experts

I am trying to get one of my forms to be just a bit narrower. It was quite happy at 20 cm wide but refuses to slim down to 19 cm (width reverts to 19.999 cm if I try to alter it).

None of the controls extends past 18 cm on the form.

Just offering 300 points initially as I suspect I am missing something dead obvious.

Hopeful Kiwi
Question by:kiwi_731
    LVL 77

    Accepted Solution

    "None of the controls extends past 18 cm on the form."

    You must be missing something here.
    Maybe there are horizontal lines that are not obvious in design view.
    But there must be something.

    You can change the form's auto-resize property to No and that will allow you to set the size narrower than the widest control - but you will get a scroll bar if you set it too narrow to show all controls.

    Author Comment

    "You must be missing something here."

    You are so right.

    It was a text box with  back style and border style transparent, special effect sunken, making box and border completely invisible except when I highlighted the box in design view. Duh!

    Must say it isn't intuitive that having a special effect set to sunken is what makes the border of the box invisible though.

    Oh well - hopefully someone else will see this and not have to ask the same question!

    Do you have any other thoughts before I hand out the points?

    Hopeful Kiwi
    LVL 77

    Assisted Solution

    When I have had this problem in the past I have dragged a 'marquee' selection using my mouse across all sections in what i consider to be the 'empty space'.  That has usually shown up the problem as the control handles become visible.

    Author Closing Comment

    Many thanks for catalyzing the solution
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    The other way to find the offending control is to click and drag in the ruler section at the top of the form or report.  This will cause every object that is in the "selected" region of the form or report to be selected, and the bright orange is hard to miss.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    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…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    734 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

    23 Experts available now in Live!

    Get 1:1 Help Now