conditional formatting, Access 2010
Posted on 2014-03-12
In a subform, there are varying number of records for CustID:
CustID ContactName Address etc.
------- ---------------- --------- ------
I want to apply alternating shade to the entire row from one CustID to the next. This way, the user can easily locate the information because the subform has many columns and fills the screen lengthwise.
Question1: How can I do this? Is there a built-in feature in the property sheet I can apply the required setting?
I supose, we can have fnRecordShade([CustID]) returing True or false when CustID changes if no other easier solution. If question 1 not possible then how should this function to look like:
Function fnRecordShade(lngCustID) as boolean
' the body of function to return true or false
' when CustID canges
fnRecordShade = True/False