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

any way to jump the cursor to a specific field (variable) while inform view?

P: n/a
Is there a way I can direct the cursor to a specific field (variable)
in a form by typing the field name while in form view?

I have a form with many fields, and it would be nice if there were
some method, similar to FIND RECORD (e.g., CTL + F ), where a dialog
box would pop up and let me enter the field name, and then jump the
cursor to that location.

I currently do my edits by locating a record to be changed by ID using
CTL+F and then I visually scan for the field I need to change. It
would be great if there were something like CTL+"V" to take me to the
'variable' I want to edit for that record.

I know that in design view I can use the toolbar dropdown variable
list to do this, but this only seems to work in form design viewl. I
need an easier way to navigate to one field that needs a value to be
corrected in the underlying table for a specific record.

I use the SAS system for some data entry applications, and it has a
keystroke combination, ALT+V+V that does this trick, but that's in
SAS. Sure wish MS-Access had some keystroke shortcut to deliver my
cursor to the exact location I want to edit on a record.

Thanks for any ideas.

-- Bill
Dec 12 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Oh, forgot to mention, I'm using Access 2003 on Windows XP.

Thanks again,

Bill McKirgan
Dec 12 '07 #2

P: n/a
On Dec 13, 12:17 am, mckbill <Bill.McKir...@gmail.comwrote:
Is there a way I can direct the cursor to a specific field (variable)
in a form by typing the field name while in form view?

I have a form with many fields, and it would be nice if there were
some method, similar to FIND RECORD (e.g., CTL + F ), where a dialog
box would pop up and let me enter the field name, and then jump the
cursor to that location.

I currently do my edits by locating a record to be changed by ID using
CTL+F and then I visually scan for the field I need to change. It
would be great if there were something like CTL+"V" to take me to the
'variable' I want to edit for that record.

I know that in design view I can use the toolbar dropdown variable
list to do this, but this only seems to work in form design viewl. I
need an easier way to navigate to one field that needs a value to be
corrected in the underlying table for a specific record.

I use the SAS system for some data entry applications, and it has a
keystroke combination, ALT+V+V that does this trick, but that's in
SAS. Sure wish MS-Access had some keystroke shortcut to deliver my
cursor to the exact location I want to edit on a record.

Thanks for any ideas.

-- Bill
There are several ways to do this - one way is to customise your form
view toolbar by adding a "go to field" item. In Access 2003, this
should work:

Open any form in form view and make sure your form view toolbar is
visible.

On the menu, select View/ Toolbars/ Customise.

On the Customise dialog, go to the Commands tab.

Under Categories, select Records.

Under Commands, scroll down until you find "Go to Field".

Drag the "Go To Field" command onto your form view toolbar.

Close the Customise dialog.
Now whenever you have a form open for editing, the toolbar will
include
a dropdown list of fields on that form, just like the one you see in
form design view.
Other approaches worth considering:
Lay out your forms so it's easier to find stuff visually e.g. use
dividing lines, pages, tabs, etc.

Use "&" in your form field labels to create your own "Access key"
shortcuts.

If you know some basic coding - Place an unbound combo box on your
form
whose row source type is "field list" and whose row source is the
same
as the form's row source. Use the combo box's After Update event to
setfocus to the selected field.

Finally, getting off the topic, but if you have very many fields to
search, your data may need to be normalised. Folks who are used to
working with statistical software like SAS tend to structure their
data in a
single flat file type data structure, often with large numbers of
columns. That's not the only way to do it, and it's not really the
right
way to set up your data in a relational database like Access. I'm
making assumptions about what you're doing here though so will leave
it
at that.
Dec 13 '07 #3

P: n/a
Helen,

Thank you for your suggestions and for your comments about data
structure.

I look forward to trying-out your ideas and will report back on how
things go.

As for data structure, I'm guilty of being a flat-file guy. I tend to
use a flat file representation of our data which are entered from
paper forms. I split things by the paper forms, but some of them have
over a hundred variables as they may run 20 or more pages for an
interview.

I have one form that has over 3000 variables and I do all of the data
entry in SAS, but it takes me a lot of time to set something like this
up. On the other hand, where I can keep things under the 255 variable
limit for Access tables I will setup data entry in Access as this
environment is much easier to for me to rapidly develop a simple
double data entry system for one or more sets of our paper data
collection forms.

Thanks again, and kind regards,
Bill McKirgan
Dec 13 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.