[AccessD] Disabling an Option Group

[Rocky Smolin]

I always usf 'fld' prefix in the table followed by the table name and then
the field name. And I name the control the same as the field's name. Never
had a problem with that. Clean livin', I guess. In that way when I'm
looking at the code I can easily see the field name and the table it came
from - makes the code more self-documenting.

r

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

> 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>