A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

using Down Arrow key to navigate



 
 
Thread Tools Display Modes
  #1  
Old May 31st, 2004, 07:00 PM
Maureen
external usenet poster
 
Posts: n/a
Default using Down Arrow key to navigate

Hi - I am hoping that someone will know how to do this.

Is there any way to use the down arrow key to select in a
combo box?
Currnetly when I use the down arrow key it sends me to
the next control based on the tab stops.

thank you in advance
  #2  
Old May 31st, 2004, 07:26 PM
StCyrM
external usenet poster
 
Posts: n/a
Default using Down Arrow key to navigate

Hi Maureen

Please refer to Microsoft article # Q98225
which reads as follows:

In Microsoft Access 7.0 and 97, you can use the Dropdown method to force
the list in the specified combo box to drop down. If the specified combo
box control does not have the focus, an error occurs. Using this method is
identical to pressing the F4 key when the control has the focus.

MORE INFORMATION
================

A macro with a single action, SendKeys, is shown below. You can use this
macro for all combo boxes on your form:

1. Create a macro called Open Combo Box, as follows:

Action
--------
SendKeys

Actions Arguments
------------------
Keystrokes: %{DOWN}
Wait: Yes

2. Open your form in Design view.

3. Add the above macro to the OnEnter property of your combo box.

4. Open your form in Form view, and use the TAB key to move to your combo
box.

Using the Dropdown Method in Microsoft Access 7.0 and 97
--------------------------------------------------------

1. Create a new form

2. Add a combo box and a text box control to the form

3. Set the combo box's OnGotFocus property to the following event
procedu

Private Sub Employees_GotFocus()
Me!ComboBoxName.Dropdown
End Sub

4. Open your form in Form view, and use the TAB key to move to your combo
box.

REFERENCES
==========

For more information about the Dropdown method, search the Help Index for
"Dropdown method," or ask the Microsoft Access 97 Office Assistant.

For more information about automatically sending keystrokes, search the
Help Index for "SendKeys," or ask the Microsoft Access 97 Office Assistant.

Best regards

Maurice St-Cyr
Micro Systems Consultants, Inc.



Hi - I am hoping that someone will know how to do this.

Is there any way to use the down arrow key to select in a
combo box?
Currnetly when I use the down arrow key it sends me to
the next control based on the tab stops.

thank you in advance








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.