Changing form colours on field selection.

[TheTruePhoenix]

I was wondering if there was anyway to make a form change colours for
certain areas (background, text input boxes, etc) if you made the data
in one field equaled a certain value (it is set to 'standard' or
'urgent'). Any ideas?

 

[Douglas J Steele]

Most controls (and form sections) have a BackColor property that you can
manipulate through code.

 

[TheTruePhoenix]

What code do you use to manipulate it though? I'm not the best with
Access or VBA coding :S

 

[Sam Hobbs]

But what is "it"?

There are some fundamentals of Access that are explained very well in the
documentation and in books and in articles available using the internet. It
is better that you use those resources for the fundamentals.

The most relevant fundamental here is that Windows windows have controls.
You need to understand that. Whetehr you do understand that or not, you are
not using the terminology associated with that understanding. It is
necessary to use appropriate terminology when discussing things such as this
because otherwise we can't understand you and you can't understand us; in
which case it is a waste of time for anyone to try to help.

If you understand about controls, then look in the documentation for a
control that you need to change the color for. If you just look in the
properties for one of the the controls, you should be able to answer your
own question.

The most important thing people need to do to get help from volunteers such
as in this newsgroup is to show that they are trying. Try to understand what
Douglas said. Look to see what he is talking about. If computers are new for
you then this is a good way to get confidence in working with them, since
this is relatively easy to do. You can learn from this.

If you are TheTruePhoenix, is it not your responsibility to rise yourself? I
hope you do, and become the best with Access and VBA coding.