F. Scott Barker's Microsoft® Access 2000 Power Programming

GIVING SPREADSHEET-TYPE CURSOR MOVEMENTS TO CONTROLS

One thing that past and present spreadsheet users find frustrating is the inability to cursor, or move, around on a form as you can on a spreadsheet. This is especially true when the form itself is set up in such a way that it resembles a spreadsheet. An example of this might be financial information for a customer going over three years.

Figure 10.29 shows an example of a form that's set up in columnar format. This form, SpreadSheetTypeMovementExample, is found on the CD-ROM in the file Chap10.mdb, in the \Examples\Chap10 folder.

Figure 10.29. Although this kind of form setup is easy on the eyes, maneuvering through it can be frustrating for some users.

Looking at the Problem

The form in