Shiortcut key to enter data in a highlighted cell?

[rik130]

Hello.



A very simple question for the experts!

In the datasheet view, when tabbing across the cells it will highlight any populated cell with a black background. Is there a shortcut key to place the cursor in the cell so that I can move the cursor through the text to make changes to it? I only seem to be able to do this by reaching for my mouse and left clicking it in the cell, which is annoying when I can perform all other functions, editing and scrolling just using my keyboard. In an attempt to explain the problem better, I can see the cursor appears at the start of the populated cell, but using the right arrow key to move the cursor through the text simply moves the 'box' to the next cell instead. I've tried holding shift and right arrow and CTRL right arrow but these also just move to the next cell. I've checked the official MS Access shortcut key list and don't see anything to perform this simple function.

Thanks .

PS. this is in Access 2007-2010 version on Windows 8.1, ignore what it says in my username tag.

[June7]

Do you mean a form in Datasheet view?

VBA code can set cursor start position.

Me.textbox.SelStart = 0

Try code in control GotFocus event.

[ranman256]

youd have to create hot keys for every text box. (not productive)

in the Access settings: FILE, OPTIONS, CLIENT SETTINGS,
change ARROW KEY BEHAVIOR to NEXT CHARACTER.

this will only affect YOUR access. Not others. Its not a database setting, its Access app setting.

[rik130]

Thanks to both. Ramman : that is exactly the 'fix' I was wanting. Perfect!

[June7]

If this will be a split db with deployed frontends to multiple users, then use VBA approach.

PS. can edit your user profile with current info.