Formatting Cells individually in a Table – Microsoft Access
I am currently in the process of using a Table to track employee annual leave,
I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read.
How do I do this?
Software/Hardware used:
Software/Hardware used:
ASKED:
November 7, 2012 12:17 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
I use ‘on current’ in the form to display the data. Below I look to see if >49 , if so then I turn data RED. I could just as easily checked for string. Probably a better way to do it but his was a simple approach.If blyrmbr.Value > 49 Then Me!blyrmbr.ForeColor = 255Else Me!blyrmbr.ForeColor = -2147483640End If