Format form for particular records

[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

 

[Allen Browne]

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.

 

[Saintsman]

Brilliantly simple!! Thanks

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.

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