[AccessD] Bang v. Dot

Stuart McLachlan stuart at lexacorp.com.pg
Fri Aug 6 05:28:07 CDT 2021

Prior to 2007, Access was very forgiving and you could mix up dots and bangs with fewer 

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.


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

More information about the AccessD mailing list