Re: change background color in continuous form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On 26 Feb 2007 10:51:08 -0800, mcnews wrote:

On Feb 26, 1:33 pm, "mcnews" <mcour...@xxxxxxxxxxxxxx> wrote:
how to change the background color of a cell/field in a continuous
form?

tia,
mcnewsxp

sorry - i meant change the background color for an entire column on a
data***.

What Access version?
Form Data*** View?
What datatype field?

If you are using Access 2000 or newer:
In form design view, use conditional formatting on that control.

If it's a number field, for example, set the Condition1 to
Expression Is
Write:
IsNull(FieldName]) or [FieldName] <= -9999

in the next dialog box.
Write -9999 (or as small a value as will work in all instances) in
the next dialog.

Run the form in Data*** view.

You can do something similar if the field is Text datatype.
Set the Expression Is to:

IsNull([FieldName]) or [FieldName] < "ZZZZ"

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Quantcast