damixa
asked on
Conditional Formatting for Form in Access
I have a form named frm_showlist that is in datasheet view. I need to do some VBA conditional formatting that basically goes like this
if Status_id = 1 format all the fields in the record in red
if Status_id = 2 format all the fields in the record in blue
if Status_id = 3 format all the fields in the record in brown
if Status_id = 4 no formatting
if Status_id = 5 format all the fields in the record in purple
I can do the conditional formatting in access but it only applies to the cell in question, I cant do it across the board for all the fields in the record
thanks in advance,
Vinnie
if Status_id = 1 format all the fields in the record in red
if Status_id = 2 format all the fields in the record in blue
if Status_id = 3 format all the fields in the record in brown
if Status_id = 4 no formatting
if Status_id = 5 format all the fields in the record in purple
I can do the conditional formatting in access but it only applies to the cell in question, I cant do it across the board for all the fields in the record
thanks in advance,
Vinnie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome!
ASKER