By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

How can I tell if I'm on a certain field?

P: n/a
Hi,
On the form's AfterUpdate event (Form_AfterUpdate) I want to determine what
field on the form my cursor is on.

If the cursor is on Field1 I want to do something, if it is on Field2 I want
to do something else.

Using VBA how do I make this distinction?

Thanks
Barry
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a


Barry Edmund Wright wrote:
Hi,
On the form's AfterUpdate event (Form_AfterUpdate) I want to determine what
field on the form my cursor is on.

If the cursor is on Field1 I want to do something, if it is on Field2 I want
to do something else.

Using VBA how do I make this distinction?


Use the ActiveControl property. This from Help:

You can use the ActiveControl property together with the Screen object
to identify or refer to the control that has the focus.

Setting

This property setting contains a reference to the Control object that
has the focus at run time.

This property is available by using a macro or Visual Basic and is
read-only in all views.

Remarks

You can use the ActiveControl property to refer to the control that has
the focus at run time together with one of its properties or methods.
The following example assigns the name of the control with the focus to
the strControlName variable:

Dim ctlCurrentControl As Control
Dim strControlName As String
Set ctlCurrentControl = Screen.ActiveControl
strControlName = ctlCurrentControl.Name

Nov 13 '05 #2

P: n/a
Thanks Teddy, appreciate your help!

<te********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...


Barry Edmund Wright wrote:
Hi,
On the form's AfterUpdate event (Form_AfterUpdate) I want to determine
what
field on the form my cursor is on.

If the cursor is on Field1 I want to do something, if it is on Field2 I
want
to do something else.

Using VBA how do I make this distinction?


Use the ActiveControl property. This from Help:

You can use the ActiveControl property together with the Screen object
to identify or refer to the control that has the focus.

Setting

This property setting contains a reference to the Control object that
has the focus at run time.

This property is available by using a macro or Visual Basic and is
read-only in all views.

Remarks

You can use the ActiveControl property to refer to the control that has
the focus at run time together with one of its properties or methods.
The following example assigns the name of the control with the focus to
the strControlName variable:

Dim ctlCurrentControl As Control
Dim strControlName As String
Set ctlCurrentControl = Screen.ActiveControl
strControlName = ctlCurrentControl.Name

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.