I have bound 16 text box in report of access.


These are arranged in tabular format
Heading of these tabular column is as
A U S NA (unbound 4 text box )

Below this 16 bound text box are as
E1A E1U E1S E1NA
E2A E2U E2S E2NA
E3A E3U E3S E3NA
E4A E4U E4S E4NA


Now A,U,S COLUMNS can have value "a" to display tick mark in webdings. And NA column can can have vaue "=" to display dot.

Now I have to count number of tick (a) and no of dot (=) and format one of the four heading unbound textbox A U S or NA
4 dots NA highlight
3 dot one tick then NA highlight
2 dot and 2 tick then A highlight
1 dot 3 tick then U highlight
4 tick then A highlight


Note in every row of bound text box any one from A,U,S,NA will have values.
A,U,S will have a for tick mark and NA will have = for dot .
Pls help me with its coding how to do the required.
Thanx