How get caption of textbox label in OnClick event?

  • Thread starter Thread starter mscertified
  • Start date Start date
mscertified said:
in the OnClick event for a textbox, can I get the caption of the associated
label?
Click to expand...


If the event knows the name of the text box:
Me.textbox.Controls(0).Caption

If you are using a general function for a bunch of text
boxes:
Me.ActiveControl.Controls(0).Caption

I suspect that you should use the Enter event instead of the
Click event so the code will run when users tab to the text
box.
 

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

Similar Threads

Getting a caption without naming the control 1
form objects lose association with VBA code.. 2
Find the label corresponding to a textbox in a form 1
UPDATE Table with multiple textboxes 6
OnClick event attached to LABEL 1
Display result of crosstab query in form 1
Change Label based on Two Combo Boxes 2
How to Show Form ComboBox value into other Form Label caption 3

Back
Top