What does me.visible means?

A

Allen Browne

Bart said:
What does "me.visible" means? What does "me" stands for?
Click to expand...

Me is a reference to the current form/report.

For example, if the current form is Form1, then Me is the same as:
Forms![Form1]
 
B

BruceM

To expand a bit on what Allen wrote (my apologies if I am stating the
obvious, but it is not entirely clear whether your question is entirely
about the use of "Me" or whether you are also trying to sort out how to use
the Visible property), the Visible property can be used to show or hide a
control, form, or report. For instance, you could have this in the Current
event of a form for recording personal information:

If Me.NewRecord Then
Me.txtMaidenName.Visible = False
Else
Me.txtMaidenName.Visible = (Me.Gender = "Female")
End If

(txtMaidenName is a text box bound to the MaidenName field)

Then, in the AfterUpdate event of the combo box Me.cboGender (bound to the
field [Gender]):

Me.txtMaidenName.Visible = (Me.Gender = "Female")

This expression evaluates either to True or False, and can be used in place
of the words True or False:
(Me.Gender = "Female")
 
Top