How to apply autoformat for an Access form from VBA?

Posted on 2006-03-30
Last Modified: 2006-11-18
Dear experts,
I am creating forms from Access VBA code, but I didn't found a way to change the form format appearance.
I am not even able to change manually the autoformat for the new form wizard, and it remains the same
Standard format.
Do you have any clue for me?
Thanks in advance!
Question by:icad01
    LVL 20

    Assisted Solution

    VB gives us lots of ways to build forms 'on -the- fly' but Access is somewhat clumsy at this.  (Access does not support control arrays).

    I think if you want multiple form appearances per situations, you'd be best off creating the separate forms and opening per user selection.

    Scott C.
    LVL 18

    Accepted Solution

    When you have created a form of your own style, you then go to Format, AutoFormat.  In the customize options, you can change any of the styles to the style used in the current form.  New forms created using wizards will use this form.
    Under Tools, Options on the Form/Report tab is an option for a Form.  Use this value to base new forms created without the wizard (hearing VBA) to use the style of the form entered.

    Author Comment

    Thanks for the answers!
    I ended creating forms with like a wizard, so I have full control.
    I first copy a form customised template, then add controls.
    Thanks again.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    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

    15 Experts available now in Live!

    Get 1:1 Help Now