To dot or not to dot...

[webturner]

I learnt long ago that I should use a dot for Methods and Properties (Me.Close or rst.RecordCount); and an exclamation mark for items in a collection (Me!cboCountiesList or rst!strForename)

But I've seen a lot of code where I work that only uses the dot. When I asked about this I was told that it brings up intellisense and the list of controls on the form for easy entry. Sure enough it does: and the exclamation mark doesn't.

I still think Forms!frmAddress!cboCountiesList.Columns(1) is more readable but Forms.frmAddress.cboCountiesList.Columns(1) is easier to enter.

What does the panel think?

 

[Remou]

Previously, on this channel, in Dot vs Bang
Me. or Me!
thread705-1127364
With links!

 

[webturner]

Brilliant, thanks, all the answers I wanted and more.