Small question regarding datasheet forms - selected text

[warmslime]

When I open a datasheet form, the first field of the first record is already selected (as in, its text is selected)



is there any way to prevent this behavior, either by changing a property or programmatically? I don't mind the cursor's position (because the user can't edit the form anyway) but I wish the text wasn't highlighted as it looks a bit ugly...

[davegri]

Create a textbox on the form and call it txtDummy. Set its width and height to .001, set left to 0, top to 0, and background transparent. Then code the form_Current event:

Private Sub Form_Current()
    txtDummy.SetFocus
End Sub

[Missinglinq]

This kind of depends on how this is used. If you go to

Options - Advanced – Behavior Entering Field

I suspect that you'll see that 'Select Entire Field' is selected. If this is a one-off database, i.e. it'll only be run on this one machine, you can chose a different option, i.e. 'Go to End' or 'Go to Beginning' of Field. The same thing goes if you want other Fields to be selected on entering (although I think this is dangerous, leading to accidental deletions) but not this one.

If it's going to be used on different machines, you can use code like

Private Sub TextboxName_GotFocus()
 TextboxNameName.SelStart = 0
End Sub

replacing TextboxName with your actual name.

Linq ;0)>

[warmslime]

Thank you all for the responses. Missingling's response was the one I applied (cause it was the fastest) and it works great.

[Missinglinq]

Glad we could help!

Linq ;0)>