[AccessD] Disabling an Option Group

[Stuart McLachlan]

That's why I hate the way Access names a control with its underlying field name.

It can often create these sorts of traps for developers.

I always rename them with the "correct" prefix i.e. chkTenantLeaseStepHeading  etc

(And I never use a superfluous prefix for fields in a table :) )



On 15 Jan 2024 at 7:33, Stuart McLachlan 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
>