Cursor Action

I

imbd4a

I am using a subform that is designed to look somewhat like a spread sheet
for ease of data entry use ( looks and feels something like the datasheet
view but not).

Anyway I can control the cursor navigation left and right thru the record
fields by Tab Order easy enough using the tab key. However, is there anyway
to use the arrow controls to do the same but especially to navigate up and
down thru the columns ?

Thanks
Brian
 
K

Kailash Kalyani

If you're using something like an excel spreadsheet you can using
Automation.. I believe you can write something like Range("A32").activate
and that will shift the cursor to A32

hope that helps...
Kailash Kalyani
Developer Support Enginer
ITWorx on behalf of Microsoft EMEA GTSC
 
A

Arvin Meyer

imbd4a said:
I am using a subform that is designed to look somewhat like a spread sheet
for ease of data entry use ( looks and feels something like the datasheet
view but not).

Anyway I can control the cursor navigation left and right thru the record
fields by Tab Order easy enough using the tab key. However, is there anyway
to use the arrow controls to do the same but especially to navigate up and
down thru the columns ?
Click to expand...

Go to Tools ... Options ... Keyboard tab

Set Move after enter to Next Field

I also set Behavior After Entering Field to end of field. The arrow keys
will work just like on a spreadsheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I

imbd4a

Thanks Arvin
But that still won't get me there. The left right arrows work alright but I
still can't get the up / down arrow keys to navigate up and down the columns
of the tabular form. Works ok in datasheet view .
Thanks
 
Top