[AccessD] Another Trick Needed

Ryan W wrwehler at gmail.com
Tue Jan 23 13:38:09 CST 2024


Would a me.repaint or something when your sorting label is clicked help?
Wonder if that would re-trigger conditional formatting?


On Tue, Jan 23, 2024 at 11:33 AM Rocky Smolin <rockysmolin2 at gmail.com>
wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list