[AccessD] Disabling an Option Group

[Charlotte Foust]

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
>