When to use ! or . (1 Viewer)

[pekajo]

Hi,
A simple question I have been meaning to ask. When using VBA what is the difference between using ! and . in say
DoCmd.GoToRecord , , acPrevious
vg = Me.IncGiven

I know the 'Me' but not the '.'
Thanks
Peter

 

[Minty]

I would read here for the definitive answer

Lets Kill the Me. vs Me! sticky or lets rewrite it

This discussion moved to clean thread https://www.access-programmers.co.uk/forums/threads/bang-vs-dot-me-and-default-properties.327749/

www.access-programmers.co.uk

 

[Ranman256]

i use ! for controls: forms!fMyform!txtBox
. to run routines: forms!fMyform.RunMyUpdate

 

[Minty]

@Ranman256 - It's more complicated than that! Have you read the link?

Personally, I only ever use the ! where I have to, as errors are not picked up with intellisense.

I have inherited a legacy system where the original developer uses Forms! type references for everything instead of Me. even when on the form he was coding.
You can't rely on compiling it to find any typos or errors if you rename or move an object, it's an absolute nightmare.
He used the same syntax for parent objects of forms as well when Me.Parent. would have been much more appropriate.

 

[NauticalGent]

I would read here for the definitive answer

Lets Kill the Me. vs Me! sticky or lets rewrite it

This discussion moved to clean thread https://www.access-programmers.co.uk/forums/threads/bang-vs-dot-me-and-default-properties.327749/

www.access-programmers.co.uk

Should be required reading on this Forum!

 

[MajP]

Do not read the whole thread go to the last post which summarizes and is more complete and more correct.