J
jen
I am trying to change the background color of each field in a record
based on the value of 1 field. There are 12 different status/12
different colors that could be set, conditional formatting only allows
for up to 3 criteria and that would be set per field. The datasheet
view does not really allow for it so I have it set up as a continuous
form for multiple records with each record having about 30 fields. The
data had previously been in an excel spreadsheet and the person is used
to looking at the color coded lines to find her information. The form
needs to open with the rows correctly color coded as well as allowing
for data entry which when the status is set would change the color of
the new row. I wonder if there would be a way to flip the color for
each row as a unit based on the Status field. I am at a loss as to how
to proceed. I have tried using a select case statement on OnCurrent for
the Form but that doesn't allow for each record. Any help would be
appreciated.
based on the value of 1 field. There are 12 different status/12
different colors that could be set, conditional formatting only allows
for up to 3 criteria and that would be set per field. The datasheet
view does not really allow for it so I have it set up as a continuous
form for multiple records with each record having about 30 fields. The
data had previously been in an excel spreadsheet and the person is used
to looking at the color coded lines to find her information. The form
needs to open with the rows correctly color coded as well as allowing
for data entry which when the status is set would change the color of
the new row. I wonder if there would be a way to flip the color for
each row as a unit based on the Status field. I am at a loss as to how
to proceed. I have tried using a select case statement on OnCurrent for
the Form but that doesn't allow for each record. Any help would be
appreciated.