Solved Why sometimes "." and sometimes "!"?

[mafhobb]

I have noticed that sometimes is certain parts of the VBA code, a "." is used and others a "!".

Is there any difference between these two? Is there a rule about their use?

Example:

Me.PropertyName.SetFocus
vs
Me!PropertyName.SetFocus

or

Forms!frmPropertyHistory![Cleanings Done].Form.Requery

Thanks
mafhobb

 

[bob fitz]

The following thread may be of interest: https://www.access-programmers.co.uk/forums/threads/bang-and-dot.299717/

 

[mafhobb]

Wow! I though that I was asking a newbie/dumb question, but I see that there is extended debate.

Thanks bob fitz

 

[gemma-the-husky]

In reality it's just the syntax of a language. The compiler knows what you mean based on the appropriate syntax, and it can't compile correctly if the syntax is incorrect.

It might confuse us, but it doesn't confuse the compiler.

 

[Isaac]

I use whatever gives me intellisense (as a general rule, probably with exceptions), thus, I go for the dot whenever I can.