Newbe - Data Entry - Home/End/Arrow Keys

[Richard Wakeman]

Hi - On a data entry screen with misc. input boxes, such as for Name,
Telephone Number, etc., when tabing down the input screen, Access will
highlight whole contents in that box. Sometimes I'd like to be able
to jump to the end or the beginning of that input box to start typing
without overwritting what's already in there. In other words, if I
key a Home or an End key, the cursor will jump to the tabs at top or
out of the screen. If I try to use the arrow keys to move in the
input box, it acts like a Tab or an Enter, and jumps to the next box.
Is there anyway to make those keys work in the input box without
having to move my hand and click the mouse in the box...?

Thanks - Richard Wakeman

[Wayne Morgan]

There are two ways around this without just using the mouse to click where
you want the cursor to be.

1) Go to Tools|Options|Keyboard tab and change the selection under "Behavior
entering field". This will affect all controls.

2) To affect only some controls, you'll need a little VBA in the controls'
Got Focus event. The commands you will need are SelStart and SelLength.

Example:
Me.ActiveControl.SelStart = 0 'start
Me.ActiveControl.SelStart = Len(Me.ActiveControl.Text) 'end

'somewhere in the middle
Me.ActiveControl.SelStart = 4
Me.ActiveControl.SelLength = Len(Me.ActiveControl.Text) - 4

--
Wayne Morgan
Microsoft Access MVP
"Richard Wakeman" <jr***@adelphia.net> wrote in message
news:4d**************************@posting.google.c om...

Hi - On a data entry screen with misc. input boxes, such as for Name,
Telephone Number, etc., when tabing down the input screen, Access will
highlight whole contents in that box. Sometimes I'd like to be able
to jump to the end or the beginning of that input box to start typing
without overwritting what's already in there. In other words, if I
key a Home or an End key, the cursor will jump to the tabs at top or
out of the screen. If I try to use the arrow keys to move in the
input box, it acts like a Tab or an Enter, and jumps to the next box.
Is there anyway to make those keys work in the input box without
having to move my hand and click the mouse in the box...?

Thanks - Richard Wakeman

[Richard Wakeman]

Mr. Morgan...

Thanks for you help! That worked perfectly. Together with the menu
settings and the SelStart's, I can move around on the input screen just
like I want to.

Richard Wakeman
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!