bang (!) verses dot (.)

[ericschramm2000]

When is it appropriate to use a bang (!) verses a dot (.) when directing objects (like text boxes) to fields (like a parameter).

i.e. =Forms![form name].field
Thanks,

 

[The_Doc_Man]

First, search this forum for an article about dot vs. exclamation point, because that was the term used in the original question. There was quite a thread.

Second, in most cases, they are interchangeable, but not always.

When dealing with a property of an object, you always use a DOT.

When dealing with a member of a collection, you often use a BANG.

BUT - in SQL, there are times where you would break that last rule, because a field is a member of a (tabledef) collection but you still use DOT for it.

 

[WayneRyan]

DCX to the rescue!

http://www.access-programmers.co.uk/forums/showthread.php?t=61539

Wayne

 

[ericschramm2000]

DCX to the rescue!

http://www.access-programmers.co.uk/forums/showthread.php?t=61539

Wayne

Thanks guys!