[AccessD] Another Trick Needed

[Rocky Smolin]

Darren, Ryan, Paul, and Jim:

Thank you for the leads. I've got some thinking to do here. I will get back
when I 1) have a solution, 2) reach all dead ends.

Thanks again.

r

On Tue, Jan 23, 2024 at 2:37 PM Darren - Active Billing <
darren at activebilling.com.au> wrote:

> in a post last week I mentioned the TabBlank thing I do. It’s precisely
> for times like this.
>
> If a user clicks on a formatted text box (That must remain enabled) that I
> use under a check box for check box highlighting, they simply end up at
> this TabBlank control.
>
> I bind the formatted field to the same field the check box is bound too.
>
> So no code or trickery needed - as soon as the check box is ticked, the
> formatted field underneath goes green or red
>
> When I do clickable "a to z" and "z to a" sorts on header labels, it’s
> always on specific fields; and thus all other field values should just
> 'follow along'.
>
> if you are sorting on say the value of that CheckBox, the formatted fields
> should just 'follow along'
>
> Is that not what’s happening here?
>
> DArren
>
> --------------------
>
> > On 24 Jan 2024, at 4: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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>