INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access Control combo box drop down list position

Access Control combo box drop down list position

(OP)
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
 

RE: Access Control combo box drop down list position

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.

RE: Access Control combo box drop down list position

(OP)
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
 

RE: Access Control combo box drop down list position


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

Quote (Herman):

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.

 

RE: Access Control combo box drop down list position

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.

RE: Access Control combo box drop down list position

(OP)
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 smile

Herman
Say no to macros
 

RE: Access Control combo box drop down list position

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close