[AccessD] Another Trick Needed

[Darren - Active Billing]

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