You did not say what version of Access you are using. I think conditional
formatting appeared in A2000.
==============================================
From A2003 Help:
In Microsoft Access, the appearance of a control on a form, report, or data
access page can differ from record to record, depending on whether:
a.. The control has the focus- you're currently in the control.
b.. The value in the control meets specified criteria.
c.. The value of an expression or a Visual Basic® for Applications (VBA)
function is TRUE or FALSE.
You can use conditional formatting (conditional formatting: Formatting the
contents of a control in a form or report based on one or more conditions. A
condition can reference another control, the control with focus, or a
user-defined Visual Basic for Applications function.) to specify that a
control has a different background color, a different font style or color,
or is available or unavailable when a certain condition is met. Unavailable
controls are dimmed.
For example, you can set conditional formatting so that if an employee's
salary exceeds $100,000, the field's background turns red. Or, you can set
formatting so that text in the City field is green and italic if a customer
resides in Seattle.
The following illustration shows conditional formatting in a continuous
form. Conditional formatting is particularly useful in a continuous form,
which displays more than one record at a time, because it's easy to spot
trends in the set of records that a continuous form displays. For example,
in the following continuous form, records whose unit price is greater than
$50.00 are highlighted in red, and records whose unit price is between
$25.00 and $50.00 are highlighted in yellow. It's easy to see which products
have unit prices that meet certain criteria.
--
Joe Fallon
Access MVP
Nakirema said:
I could not find the Conditional Formatting option. Could some one
provide more detailed help? I did check out that web site, however, I have
no idea what i'm looking at.
