[AccessD] Disabling an Option Group

[John Colby]

I don't know.  What I do know is that if you create a colored label behind
the record and make it visible, it only makes it visible for that record.
So I suspect that it will only disable the option group for that record.
Try it and see.

On Sat, Jan 13, 2024 at 1:48 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> If I make the option group disabled if the header field is true will it
> only disable the option group on those records?
>
> r
>
> On Sat, Jan 13, 2024 at 10:09 AM John Colby <jwcolby at gmail.com> wrote:
>
> > I discovered the other day that there is an OnFormat event which fires
> for
> > every line of a continuous form.  In that you can liik at the value of a
> > field in that record and do stuff...  You might want to investigate doing
> > it this way?
> >
> > On Sat, Jan 13, 2024 at 12:17 PM Rocky Smolin <rockysmolin2 at gmail.com>
> > wrote:
> >
> > > Well, it's a continuous form so if the user selects a header record,
> then
> > > all the option groups would turn disabled. A bit confusing for them.
> > >
> > > What I did was put code in wherever this option group appears:
> > >
> > > Private Sub fldTenantLeaseStepUrgency_Click()
> > >     If Me.fldTenantLeaseStepHeading = True Then
> > > Me.fldTenantLeaseStepUrgency = Null
> > > End Sub
> > >
> > > Now the header record has a pale purple background so it's obvious
> > looking
> > > at the list of steps which ones are headers. And so there's no reason
> to
> > > ever click on that field. But if they do nothing happens. And hopefully
> > at
> > > that point they'll think "D'oh. That is a header record, stupid.  Why
> am
> > I
> > > trying to select an urgency?"
> > >
> > > (Users (sigh). You never know what they're going to do next...")
> > > r
> > >
> > > On Thu, Jan 11, 2024 at 6:54 PM Charlotte Foust <
> > charlotte.foust at gmail.com
> > > >
> > > wrote:
> > >
> > > > Hide a disabled (empty datasource) option group on the header in the
> > same
> > > > location as the active one. Toggle visibility in the OnCurrent event
> of
> > > the
> > > > form.
> > > >
> > > > Charlotte Foust
> > > > (916) 206-4336
> > > >
> > > >
> > > > On Wed, Jan 10, 2024 at 7:29 AM Rocky Smolin <rockysmolin2 at gmail.com
> >
> > > > wrote:
> > > >
> > > > > Yes, that would work if the user tried to change the urgency on a
> > > header
> > > > > record. But only when that record on the continuous form is
> selected.
> > > > >
> > > > > The client wants a visual cue that the urgency field is not
> disabled.
> > > > >
> > > > > (Clients…you never know what they’re going to ask for next…😛)
> > > > >
> > > > > R
> > > > >
> > > > > On Tue, Jan 9, 2024 at 11:51 PM Gustav Brock via AccessD <
> > > > > accessd at databaseadvisors.com> wrote:
> > > > >
> > > > > > Hi Rocky
> > > > > >
> > > > > > Maybe you, at the OnCurrent event, could lock the option group if
> > the
> > > > > > record is a heading?
> > > > > >
> > > > > > /gustav
> > > > > >
> > > > > > ________________________________
> > > > > > Fra: AccessD <accessd-bounces+gustav=
> > cactus.dk at databaseadvisors.com>
> > > > på
> > > > > > vegne af Rocky Smolin <rockysmolin2 at gmail.com>
> > > > > > Sendt: 10. januar 2024 00:27
> > > > > > Til: Off Topic <dba-ot at databaseadvisors.com>; Access Developers
> > > > > > discussion and problem solving <accessd at databaseadvisors.com>
> > > > > > Emne: [AccessD] Disabling an Option Group
> > > > > >
> > > > > > Dear List:
> > > > > >
> > > > > > I have a continuous form with a procedure - series of steps. Some
> > of
> > > > > those
> > > > > > records are "Headings" - not operational steps. Each step also
> has
> > a
> > > > > > priority or urgency field which is an option group with five
> option
> > > > > > buttons.
> > > > > >
> > > > > > I have used conditional formatting to make the background of the
> > > fields
> > > > > of
> > > > > > the heading lines purple - non-heading line fields are white.
> > > > > >
> > > > > > Client now would like to have the option group on the heading
> lines
> > > > > > disabled. But conditional formatting doesn't appear to be an
> option
> > > for
> > > > > an
> > > > > > option group. (At least not in Access 2010, which is what I'm
> > using.)
> > > > > >
> > > > > > I'm going to give him the bad news that option groups don't
> > > > > > support conditional formatting. He'll be OK with that.
> > > > > >
> > > > > > But...does anyone have any clever or kludgey ideas to give him
> what
> > > he
> > > > > > wants?
> > > > > >
> > > > > > MTIA
> > > > > >
> > > > > > r
> > > > > > --
> > > > > > 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
> > > > >
> > > > --
> > > > 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
> > >
> >
> >
> > --
> > John W. Colby
> > Colby Consulting
> > --
> > 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
>


-- 
John W. Colby
Colby Consulting