MSAccess table design dropdown fieldlist to move cursor to field

[Norman Simoneau from ProSo.Net]

Please change Microsoft Access table design to allow easy navigation to the
specific field the user wants to go to. A drop down list should be added to
the top of the table design window (perhaps the gray column label area that
reads "Field Name" on the top of the table design window could be a dropdown)
to allow quick search for a specific field. The dropdown list would be a
list of all field names within the table in design mode. By selecting the
fieldname from the dropdown list the cursor would automatically move to that
fieldname with the cursor at the end of the field. The feature will work
like the procedure dropdown in module design. Also, please add this feature
to the Macro design window to allow quick cursor positioning by macro name
within the macro in design. Thank you. Sincerely, Norman Simoneau,
www.ProSo.Net


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...043&dg=microsoft.public.access.tablesdbdesign

 

[mscertified]

That would require two clicks; one to open the drop down and one to select
the field. Currently I can get there in one click I may need to scroll but
you may need to scroll the drop-down too.

 

[Norman Simoneau from ProSo.Net]

The idea to to have a dropdown that works like an Access combobox. The
dropdown list would be an alphabetical list of all field names within the
table in design mode. As you begin to type within the dropdown list the
list will update to display the appropriate field as you type. When you
press enter the cursor will automatically scroll to the appropriate field in
the table design. Currently, you can scroll through the field names;
however, they are not in alphabetical order. Having a dropdown list of all
field names in alphabetical order on the top of table design would allow
quick lookup like the way the combobox is used to lookup names in an
alphabetical list.

 

[tina]

normalized tables usually don't have more than 25-30 fields, tops - and
often much, much less. that's not much to look through when you go into
table Design view, especially if the window is maximized.


"Norman Simoneau from ProSo.Net"

The idea to to have a dropdown that works like an Access combobox. The
dropdown list would be an alphabetical list of all field names within the
table in design mode. As you begin to type within the dropdown list the
list will update to display the appropriate field as you type. When you
press enter the cursor will automatically scroll to the appropriate field in
the table design. Currently, you can scroll through the field names;
however, they are not in alphabetical order. Having a dropdown list of all
field names in alphabetical order on the top of table design would allow
quick lookup like the way the combobox is used to lookup names in an
alphabetical list.

http://www.microsoft.com/office/com...043&dg=microsoft.public.access.tablesdbdesign

 

[Norman Simoneau from ProSo.Net]

Wth 25-30 fields, an alphabetic dropdown lookup would be useful on table
design to move the cursor to the field name. This would also be useful in
macro design by macro name. Some macros have dozens of macro names within a
macro with hundres of lines. I've been developing for over 26 years---13
year in Access. (since version 1.1) This would increase the efficiency of
using table & macro design by having a dropdown alpha lookup by field name
(or macro name in macos.)

 

[tina]

well, if enough people think it would be a significant improvement, maybe MS
will include it in the next version.


"Norman Simoneau from ProSo.Net"