[AccessD] Another Trick Needed

[Rocky Smolin]

Dear List:

This is not a requirement by the client - just an 'it would be nice if...'
and I'd like to find a way to do it.

I have a continuous form with three checkboxes on it. The checkboxes are
bound to fields in a table. The client requested that if a certain
CONDITION applied to any of the three that somehow that checkbox would be
made to stand out or be identified visually.

Because conditional formatting cannot be used  on a checkbox, I put a box
behind the checkbox with borders a little larger than the checkbox. I then
used conditional formatting on the box behind the checkbox. If the checkbox
CONDITION is TRUE then the box backcolor is turned red so that the checkbox
appears to have a red border.  If the CONDITION is FALSE then the
backcolor of the box behind the check box is the same as the backcolor of
the detail section.

The client was delighted.

For a couple of weeks. Then he asked for a tweak.

On this continuous form I have labels at the top of each field. Like many
of my continuous forms, I put some code in the click event of the label
which sorts the column ascending.  Another click - descending. Client loves
that feature.

But now, when he clicks the label at the top of one of the three
checkboxes, all the boxes WITH checks sort together either at the top or
bottom of that column. But even though the checkboxes checked TRUE are all
grouped together, the ones with the red border are not. They are sprinkled
randomly along the list of checked boxes.

So what he asked for was to have the checkboxes marked TREU WITH the red
border sorted together, followed by the checkboxes marked TRUE without the
border.

I puzzled over this for quite a while but cannot figure out a way to do it.

Any ideas?

As I say, the client is delighted with the program - 'lives and dies by it'
he says (which is gratifying) - so I get no points off if I can't do this.

MMTIA,

Rocky