By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Newbe - Data Entry - Home/End/Arrow Keys

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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!
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.