[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 
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
> 




More information about the AccessD mailing list