How to apply autoformat for an Access form from VBA?

Posted on 2006-03-30
Medium Priority
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

clarkscott earned 600 total points
ID: 16335450
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 19

Accepted Solution

Richard Daneke earned 1400 total points
ID: 16337891
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

ID: 16363909
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.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

831 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