[AccessD] Another Trick Needed

[Darren - Active Billing]

the trick is binding the formatted control (a text box) to the dB field for the check box


----------------------------------------

> On 24 Jan 2024, at 9:37 am, 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
>