Access 2003 problem

[kirkm]

Often when designing, or coding I notice a datasheet-view form plays up. When you click in the field instead of just showing the cursor, part or all of the text becomes selected, preventing any editing. I can find no way to fix it, apart from close and re-open Access.

But maybe there is ?

 

[arnelgp]

i think that is default behavior, when you tab to the control.
if you dont like the text to be selected when you enter the control, you can use code.
on GotFocus event of the control:

private sub control_GotFocus()
with Me.control
' put the cursor at the beginning of the text
.SelStart=0
.SelLength=0

'or put the cursor at the end of the text
'.SelStart=Len(Me.control.Text)
end with
end sub

 

[Guus2005]

... or hit the escape key twice. Toggles special keyboard settings.

HTH

 

[kirkm]

Thanks Guus Will try that next time. Don't think arnelgp knew what I meant.

 

[apr pillai]

Post few Screen-shots so that your specific issue will have more clarity.

When the field get focus on Form the Cursor behavior (1. select entire field, 2. go to start of the field 3. go to end of field) is controlled by the Behavior Entering Field setting under Advanced options in Access Options settings. The first option Select Entire Field is set by default.

You may set one of the other two options to put the cursor at the beginning or end of the field data.

This setting will not interfere with Coding.