How to UN-highlight a field

S

svbl

Registered User.

Local time

Yesterday, 19:21

Joined

Jul 10, 2007

Messages

20

• Jul 16, 2007

• #1

Hi. I have a form with tabs that also contain subforms within them. When I click through each tab, ONE field in the subform is highlighted with the cursor in that field.

This gets really annoying when I just want to view the data and not enter in data. Is there anyway I can prevent this?

Thanks!

 

mhartman

Dr. Data

Local time

Yesterday, 17:21

Joined

Jun 5, 2006

Messages

442

• Jul 16, 2007

• #2

Hello

If you are familiar with VBA you can use the SelStart property do this. It cancels the selection. Its in the help section.

Regards
Mark

 

S

svbl

Registered User.

Local time

Yesterday, 19:21

Joined

Jul 10, 2007

Messages

20

• Jul 16, 2007

• #3

THANK YOU for the reply.

Unfortunately I am not. Are there any other options, or another way you can help explain it to me?

 

mhartman

Dr. Data

Local time

Yesterday, 17:21

Joined

Jun 5, 2006

Messages

442

• Jul 16, 2007

• #4

Hello:

Here is an article with an example:

Regards
Mark

http://msdn2.microsoft.com/en-us/library/aa218286(office.10).aspx

 

mhartman

Dr. Data

Local time

Yesterday, 17:21

Joined

Jun 5, 2006

Messages

442

• Jul 16, 2007

• #5

Hello:
If you had a control named TEXT1 on your form, the below code would put the cursor at the beginning of the text box.
This would go in the Form Current event of your form.

Regards


Private Sub Form_Current()
Me.Text1.SetFocus
Me.Text1.SelStart = 0

End Sub