Selstart, Sellength in Datasheet View

  • Thread starter Thread starter Tim Doherty
  • Start date Start date
T

Tim Doherty

Hello all,

I have a form in datasheet view. Several textboxes have as their OnEnter
event procedure:

Screen.ActiveControl.SelStart=0
Screen.ActiveControl.SelLength = Len(Screen.ActiveControl)

In order to select the entire contents of the field for data quick data
entry. In Form view, this works as expected, but in Datasheet view, the
selection is lost once the OnEnter event completes. Stepping through the
code, the contents of the field are selected immediately following the
SelLength statement, but after the End statement, the cursor simply appears
at the end of the field contents.

I can find no events encaspulating or immediately following the OnEnter
event.

Any comments/suggestions greatly appreciated. Thanks,

Tim Doherty
 
It is possible that the "Keyboard" Options affecting this.

Use the Menu Tools / Options ... / Keyboard tab and experiment with the
setting of "Behavior Entering Field".
 
Back
Top