View Full Version : Graying out record based on field value


lscheer
11-01-2001, 02:09 PM
Is it possible to make a specific record (in a form) grayed out when a field "Active?" is designated as "inactive"? I need to keep the person in the db for tracking purposes, even if they are no longer an active participant.

SteveA
11-01-2001, 11:53 PM
In the OnCurrent event of your form place code like:

Me.AllowEdits = Me.blnActiveRecord

Change Me.blnActiveRecord to point to the flag you are using to indicate the active record.

HTH
SteveA