What does "!" mean in VBA

Question

Can somebody please tell me what the "!" means in line 5 of the following?

Dim rst As Recordset
Dim db As Database
Set db = CurrentDb
Set rst = db.OpenRecordset("zTableFields", , dbAppendOnly)
rst!TableName = "Brad"

Thanks.

possible duplicate of [Bang Notation and Dot Notation in VBA and MS-Access](http://stackoverflow.com/questions/2923957/bang-notation-and-dot-notation-in-vba-and-ms-access) — pmcoltrane, Dec 23 '14 at 16:45

score 1 · Answer 1 · answered Dec 23 '14 at 17:47

1

It is the delineator between the table or query name, and the field/column name.

These are identical:

    rst.Fields.Item(TableName).value = "Brad"
    rst.Fields(TableName) = "Brad"
    rst(TableName) = "Brad"

answered Dec 23 '14 at 17:47

Brian Wren

2

It is called the "bang operator." – Brian Wren Dec 23 '14 at 17:47
1

Read this for an extensive explanation. http://bytecomb.com/the-bang-exclamation-operator-in-vba/ – Jens Dec 24 '14 at 08:32
You forgot the `!` example. – Timo Aug 25 '20 at 08:13

1 Answers1