Make Insertion cursor go to start of field in an Access 2007 subform

[johnfrani]

I have an Access 2007 app. I don't want the whole data field selected when a subform opens (too easy for the user to delete data). I have gone to Access Options / Advanced and set the cursor entering field behavior to: "go to start of field". This works for all of the forms in the app but NOT for subforms. In subforms, the WHOLE data field is selected when the subform opens. The subforms are datasheets.

How can I make the cursor go to the start of the first subform field?

Thanks, John

 

[TheAceMan1]

How are ya johnfrani . . .

Can you not select the same for subforms when you open them [blue]independently[/blue]! ...

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[johnfrani]

Going to Access Options / Advanced and setting the cursor entering field behavior to: "go to start of field" (I thought) was suppose to be a global setting to effect ALL data entry fields on forms and subforms in this database. In my app, it only works for primary forms, not subforms that are datasheets (look like spreadsheets). I know of no way to adjust this setting only for subforms. That is the help I am looking for.
Thanks, John

 

[TheAceMan1]

How are ya johnfrani . . .

What is the name of the subform in question and the control/field of interest?

What event are you currently using? ... Post your current code to perform this! I'm currently believeing something like:

[blue]   Me.[subformname].SetFocus
   [subformname]![ControlName].Setfocus
   Me![ControlName].SelStart = 0[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[johnfrani]

Thank you for your help. I have found a solution.

I have a form that has a Tab Control. On one of the Tabs, I have a subform that has been causing the problem above.
I found some code that causes the cursor to position itself at the start of the data in the first field of the subform.

In Design Mode, I selected the first data field. This was the one where ALL of the data in the field was selected.

Using the GotFocus event, I entered this code...

Private Sub Description_GotFocus()
Me!Description.SelStart = Me.Description.SelStart
End Sub

Now, when I select the Tab with the subform, the cursor behaves correctly, for my application.