Access Control combo box drop down list position 1

[hermanlaksko]

Normally when opening a combo box, it's list will drop down to either the right or left side, however would it be poss to choose/control the side and not have it "dictated" , via vba.

Also would it be poss to detach the list from the combo box itself ?
Thanks for any reply in advance.

Herman
Say no to macros

 

[kjv1611]

This question based off of original question and discussion found here: (for reference)
thread702-1598485

 

[kjv1611]

hermanlaksko,

Some APIs can basically be run the same as basic VBA modules. For instance, there's the SendKeys API that I've used in the past, which was basically just a few procedures pasted into a VBA module, and then called from other procedures/functions:

http://www.mvps.org/access/api/api0046.htm

Well, that obviously may not be the be-all/end-all, but it may give you at least a glimpse into what you're looking to do, based on your last post in the other thread.

 

[hermanlaksko]

Hi Kjv

Thx for your reply.
I am avare of the basics of the API's and I was looking for one that could help me in accomplish the control of a combo box and it's dropdown list.
The sendkeys feature will not, as I see it, help me in this.
But thanks for your interest and effords.

Herman
Say no to macros

 

[kjv1611]

Herman, Yes, I realize that it will not DIRECTLY help you in the situation. However, from your statement in the other thread:

I dont mind using an API call, I am just not sure how

I had nothing to go on, but the fact that you did not know how to use an API. What better way to see HOW to use an API than by reading up on the creation and usage of one. Thus, the example I readily think of, since it's one I've personally used on a few different occasions.

As to the specific API, try this search.

 

[MajP]

Take a look at this demo. Works pretty well.

http://www.4shared.com/file/259019696/5b2fc7d5/detachedCombo.html

See if it gives the desired "detached" effect. Still need to code
1)Simulate auto expand so when you type in the textbox it goes to the first matching record in the list.
2)Add a "limit to list" check.

 

[hermanlaksko]

Hi MajP

Thanks for your effords.
It was not the solution I was looking for but your solution is defenetly useable and is the solution I'll use for now.

If I find a better one I'll let you you know - Thx a mill

Herman
Say no to macros

 

[MajP]

Yes if you get a solution please post back for everyone's knowledge. Also post a screen shot so I can understand the effect you are trying to achieve.