Format form for particular records

  • Thread starter Thread starter Saintsman
  • Start date Start date
S

Saintsman

I am maintaining an address list & have a tick box to indicate if the record
is current
Is there a way that I can somehow grey out the record if it is not current?
I don't want to delete the record, but would be nice for users as a reminder
not to use
 
You can use Conditional Formatting (CF) to achieve this (assuming Access
2000 or later.)

In form design view, select one of the important boxes, and choose CF on the
Format menu. Set up Condition 1 to:
Expression [Inactive] = True
substituting the name of your yes/no field for Inactive. The choose the
formatting you want to use when the condition is true.
 
Brilliantly simple!! Thanks

Allen Browne said:
You can use Conditional Formatting (CF) to achieve this (assuming Access
2000 or later.)

In form design view, select one of the important boxes, and choose CF on the
Format menu. Set up Condition 1 to:
Expression [Inactive] = True
substituting the name of your yes/no field for Inactive. The choose the
formatting you want to use when the condition is true.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Saintsman said:
I am maintaining an address list & have a tick box to indicate if the
record
is current
Is there a way that I can somehow grey out the record if it is not
current?
I don't want to delete the record, but would be nice for users as a
reminder
not to use
Click to expand...
Click to expand...
 
Back
Top