Move between same field on different records

[jkfeagle]

I've created a database for a group and they have requested that in one of the data entry forms (a continuous form) that they enter the data vertically instead of horizontally. What I mean by this is they want to jump from one record to the next but within the same field as they enter data. I know there is an option within the Access program to allow this but on the machine they use, the database opens in runtime mode and the option of intalling the full Access program on the machine is a problem because it would increase costs. If worse comes to worse we probably could bite the bullet and install the full Access program but if at all possible I would like to avoid this.

Is there a means of allowing the enter key, the tab key or the arrow keys to do this?

 

[Big Pat]

I'm afraid I can't think of any way of doing this in Access.

One possible option is to use Excel for your data-entry, because Excel "prefers" moving downwards. You would then have the spreadsheet as a LINKED table in your Access database.

This will work if your Access form is pretty basic, but if you use lookups and combos and stuff like that, then it may not be worth it, as you may create more problems than you solve.

Pat