[AccessD] Disabling an Option Group

[Rocky Smolin]

In defiance of Access conventions I always make the bound field name and
the control name the same.

r

On Sun, Jan 14, 2024 at 1:34 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> That won't work with a recordset field.
> Do you have a control (textbox, checkbox or whatever) with that name?
> If not, put a hidden one on the form.
>
> On 14 Jan 2024 at 13:18, Rocky Smolin wrote:
>
> > I tried
> >
> > Private Sub Detail_Paint()
> >     If Me.fldTenantLeaseStepHeading = True Then
> > Me.fldTenantLeaseStepUrgency.Enabled = False ELSE
> > Me.fldTenantLeaseStepUrgency.Enabled = True
> > End Sub
> >
> > I turned the option group control in all the record to disabled, and
> > then errors that it couldn't find fldTenantLeaseStepHeading.
> >
> > r
> >
> > On Sun, Jan 14, 2024 at 12:37PM Stuart McLachlan
> > <stuart at lexacorp.com.pg> wrote:
> >
> > > Godd call.
> > > You always need a construct such as
> > >
> > > Private Sub Detail_Paint()
> > >     If Num1 = 6 Then
> > >         Text3.BackColor = &H666666
> > >     Else
> > >         Text3.BackColor = &HFFFFFF
> > >     End If
> > > End Sub
> > >
> > > when doing something with individualn rows in a continuous form or
> > > report. to avoid incorrect results.
> > >
> > >
> > > On 14 Jan 2024 at 14:18, John Colby wrote:
> > >
> > > > Rocky, is the field true for every record?  It feels like there
> > > > should be an else which sets enabled to true.
> > > >
> > > > Did you watch the youtube video for that part where the presenter
> > > > discussed what he was doing.
> > > >
> > >
> > > --
> > > 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
>