I accidently fixed it. I added the PrepareSQL procedure for the HotQ
query because I had some combo boxes for filtering the result set.
After that the coloring worked correctly. When I commented out the
code in the PrepareSQL procedure, the coloring was incorrect again.
After un-commenting out, it worked. That's kind of strange that I
need that procedure to cause the coloring to be correct when the sort
order is changed.

Stan Walker