[AccessD] Bang v. Dot

[Rocky Smolin]

I have consistently broken oe of the basic rules of VBA - giving different
names to the object and the control source of the object.  When I bind a
text box, for example to fldABC, I give the text box the name fldABC
instead of txtABC.  It has saved me a lot of trouble and makes my code
easier to maintain.  And I don't have to struggle with knowing whether I
should use fldABC or txtABC.

II know - bad boy.  But it works for me.

r

On Fri, Aug 6, 2021 at 6:06 AM Ryan W <wrwehler at gmail.com> wrote:

> I think a lot of the confusion comes from the fact that all your controls
> on a form also end up in collections, which can be bang notated.... in fact
> I think for a time that was considered "proper" to use a bang to access a
> control, and then naturally a dot to access a property of the control.
>
> eg
>
> Me!Username.SetFocus
>
> which is shorthand for
>
> Me("Username").SetFocus
>
> I use this page when I need a refresher:
>
> http://access.mvps.org/access/forms/frm0031.htm
>
> There were some articles written by the late David Fenton scattered around
> the web that suggested MS Access did not corrupt as easily during compiling
> or decompliling if you used bangs in place of dots where appropriate.   I'm
> unsure if that still holds true.
>
>
>
> On Fri, Aug 6, 2021 at 7:35 AM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > Thanks  Stuart.
> >
> > On Fri., Aug. 6, 2021, 6:28 a.m. Stuart McLachlan, <
> stuart at lexacorp.com.pg
> > >
> > wrote:
> >
> > > Prior to 2007, Access was very forgiving and you could mix up dots and
> > > bangs with fewer
> > > problems.
> > >
> > > In 2007, MS tightened it up and applied the rules more consistently.
> > >
> > > In essence:
> > > A bang (!) indicates that what follows is a element of a collection.
> > > A dot (.) means a property, collection, or method name.
> > >
> > > For recordsets.
> > > rs.Addnew  '  method so it's a dot
> > > rs!Firstname = "Fred"   'it's an element of the recordset collection
> so a
> > > bang
> > > rs.Update ' again a method, so a dot.
> > >
> > >
> > > --
> > > Stuart
> > >
> > > On 6 Aug 2021 at 4:09, Arthur Fuller wrote:
> > >
> > > > When working with recordsets; I have seen both bang (rs!) and dot
> > > > (rs.) References. Wh6 is the difference? -- 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
>