[AccessD] Disabling an Option Group

[Rocky Smolin]

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
>