what's the difference of using Forms! or [Forms]!

[joe55555]

hello guys,



i'm sort of new in access vba (im using access 2013), i understand all the concepts and basics but some stuff in access are different from excel

i noticed sometimes when calling a form they use:

Forms!FormName!Control
or
Forms![FormName]![Control]
or
[Forms]![FormName]![Control]

what is the real difference and when to use each one !?

Thank you

[June7]

In objects (queries or form/report controls), Access will add the [] when it can. But they are really normally only required when names have spaces or special characters/punctuation (underscore is exception) or names are reserved words. This is why it is a good idea to avoid those. There are a few situations where they are required regardless and you must remember to type them.

[joe55555]

Alright I see, well thank you June7