FORMS - Give consistent visual appearance to all.

[ssb]

Hello,

I have multiple forms in my access application. I want all the forms
to have consistent formatting for fields appearing on the forms (i.e.
same background color, fonts, font color etc).

Obviously, it can be done manually. But is there some template
mechanism which when applied to the forms, they automatically get
required formatting?

Thanks for the help.

[Clive Moss]

"ssb" <ma******@yahoo.com> wrote in message
news:de**************************@posting.google.c om...

Hello,

I have multiple forms in my access application. I want all the forms
to have consistent formatting for fields appearing on the forms (i.e.
same background color, fonts, font color etc).

Obviously, it can be done manually. But is there some template
mechanism which when applied to the forms, they automatically get
required formatting?

Thanks for the help.

Open a form with the required design in design view, go to Format >> Auto
format. In the dialogue box click options where you will find an option to
set an auto format based on the current form.
You can then apply that format to all other forms

Clive

[Larry Linson]

ma******@yahoo.com (ssb) wrote in message news:<de**************************@posting.google. com>...

Hello,

I have multiple forms in my access application. I want all the forms
to have consistent formatting for fields appearing on the forms (i.e.
same background color, fonts, font color etc).

Obviously, it can be done manually. But is there some template
mechanism which when applied to the forms, they automatically get
required formatting?

Yes, there is a way to format a Form to your desired appearance and
then take a menu action to use that as a template. Unfortunately, I
didn't find it carried with it the details for controls, etc., so what
I did was to create a Form with formatting done "my way" including
controls that I might want to use... then I copied that as the basis
for new forms. If you copy the controls, you don't get event code and
I generally don't want it, but you do get the properties.

Another, even easier way, is to use the bog-standard Access defaults.
You may not find them as attractive, but you don't have to do anything
to carry them forward.

Larry Linson
Microsoft Access MVP

[James Fortune]

ma******@yahoo.com (ssb) wrote in message news:<de**************************@posting.google. com>...

Hello,

I have multiple forms in my access application. I want all the forms
to have consistent formatting for fields appearing on the forms (i.e.
same background color, fonts, font color etc).

Obviously, it can be done manually. But is there some template
mechanism which when applied to the forms, they automatically get
required formatting?

Thanks for the help.

This doesn't help solve your problem, but consider using a unique
color for the background color of each form. The reason for this is
that the different colors give the user more visual context concerning
where they are in the hierarchy of forms. Also, users have told me
that very light colors are much nicer on the eyes than the standard
colors shown in the design mode of the form. You can go into Paint
.... Colors ... Edit Colors ... Define Custom Colors and select a light
version of a color. Then you can use the RGB values shown to obtain
the Access color number to place in the BackColor property of the
form:

AccessColor = B * 65536 + G * 256 + R

James A. Fortune