ms access - MSAccess - Conditional Formatting in Adjacent Rows [Solved] -

i trying add conditional formatting msaccess datasheet. want highlight following condition:

number  description ======  ============== 1111    same desc 1111    same desc 2222    different desc 1 2222    different desc 2 2222    different desc 3 

for adjacent rows, number matches, compare adjacent descriptions (note: datasheet sorted number & description when presented user in subform):

when descriptions match, nothing. when descriptions mismatch, highlight description

in example above, i'd highlight 3 rows number 2222.

i can work in xls using , and or formulas. not sure how accomplish in msaccess.

any ideas?

thanks!

i have solution, essentially:

compare qty (dcount) of rows containing current "number" alone number of rows containing current "number" , "desc". if qty of rows of "number" > qty rows of "number & desc", there variation in desc - apply highlight.

conditional formatting criteria:

 dcount("[number]","mytable","[number] = '" & [number] & "'") > dcount("[number]","mytable","[number] = '" & [number] & "'and [desc] = '" & [desc] & "'") 

provides need.

yay