Form Question

[BR]

Could someone please explain the diffrences between using
me. in a form versus using me! ?

What might each be used for?


Thanks

 

[fredg]

Could someone please explain the diffrences between using
me. in a form versus using me! ?

What might each be used for?

Thanks

Me![Control On The Form]
Me.A Property Of The Form

for example:

Me![LastName] = "Jones"
[LastName] is the name of a control on the form

Me.Caption = "Sales data entry"
Caption is a form property.

For the most part you can use the dot in both instance and it will
work i.e. Me.[LastName].BackColor = vbRed will work.
You cannot use the bang in both instances.
Me![LastName]!BackColor = vbRed will not work.