Form Question

B

BR

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

What might each be used for?


Thanks
 
F

fredg

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

What might each be used for?

Thanks
Click to expand...

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.
 
Top