What does me.visible means?

  • Thread starter Thread starter Bart
  • Start date Start date
Bart said:
What does "me.visible" means? What does "me" stands for?

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]
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top