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 » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combobox Dropdown jump to selections starting with E's



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2010, 10:09 PM posted to microsoft.public.access.queries
Iram
external usenet poster
 
Posts: 122
Default Combobox Dropdown jump to selections starting with E's

Hello,

I have a combobox field with selections starting from A through Z. When I
click on the combobox I need the drop down to skip down to the E's - Z's. In
other words skip all the A's, B's, C's, D's and start with the E's. I still
want the ability to scroll up into the A's through D's. Could you help me
with this?


Thanks.
Iram/mcp
  #2  
Old May 9th, 2010, 03:58 AM posted to microsoft.public.access.queries
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Combobox Dropdown jump to selections starting with E's

Iram wrote:
I have a combobox field with selections starting from A through Z. When I
click on the combobox I need the drop down to skip down to the E's - Z's. In
other words skip all the A's, B's, C's, D's and start with the E's. I still
want the ability to scroll up into the A's through D's.



Well, the problem with what you asked is that combo box's
behave differently depending on where you click on them. If
you click on the down arrow the list will drop, but if you
click in the text poertion, it just positions the cursor for
editing the text in the box.

IF you are talking about some other control having the focus
at the time you click in the combo box, you could use the
GotFocus event to drop the list regardless of where you
click in the combo box:
Me.combobox.DropDown

Positioning the combo box's scroll bar so the first E entry
is at the top of the list is not something that Access
provides a setting for. On the other hand, all that is auto
matic if the combo box's AutoExpand property is set to Yes.
Then when you tab into the combo box and type an E or the
first letter of any entry in the list to auto position the
list to the first item that starts with the letter.

OTOH, if your users are totally locked in on only using the
mouse, you can simulate typing an E in the GotFocus event by
using:
Me.combobox.Text = "E"

--
Marsh
MVP [MS Access]
 




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 05:41 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.