By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

Combobox dropdown design

P: 3
Normally, the dropdown list drops down and flows to right if there are multiple columns being displayed. Because my drop down are on right side of form, I would like the list to be anchored to right-most column and flow to the left so all columns display. Is this possible and how?
Sep 16 '08 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,343
The widths of the columns are specified in the design of the ComboBox. If you design it so that the width available matches the sum of all the column widths, then you don't have the issue to start with.
Sep 16 '08 #2

P: 3
The number of columns=3 @ 1" ea. list width=3". Idea is to anchor (not bind)dropdown to rightmost field not leftmost which is default.
Sep 16 '08 #3

NeoPa
Expert Mod 15k+
P: 31,343
Oh NOW I know what you're on about (I think). I had to read it three or four times but I guess you mean you want the third column to be the one whose value is returned as the value of the ComboBox control.

That is done by setting the Bound Column to 3 (instead of the default of 1). This can be done in Design mode, but also on the fly if required (Me.YourComboBox.BoundColumn = 1).

Hope this helps, and welcome to Bytes!
Sep 16 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
I don't think the OP is talking about which column is bound. His multi-column combobox is located flush against the right hand edge of his form. When a combobox drops down, the left hand side of the drop down is flush with the left hand edge of the combobox, and the drop down extends to the right, as far as need be to display the fields. The problem is, it'll extend to the right beyond the border of the form. The OP wants to have the drop down flush with the right side of the combobox, and extend as far to the left as is needed to display all fields, thus not going beyond the border of the form. In other words, he wants to "flip" the combobox right-to-left.

Unfortunately, I don't know of any way to accomplish this.

Linq ;0>
Sep 16 '08 #5

P: 3
I don't think the OP is talking about which column is bound. His multi-column combobox is located flush against the right hand edge of his form. When a combobox drops down, the left hand side of the drop down is flush with the left hand edge of the combobox, and the drop down extends to the right, as far as need be to display the fields. The problem is, it'll extend to the right beyond the border of the form. The OP wants to have the drop down flush with the right side of the combobox, and extend as far to the left as is needed to display all fields, thus not going beyond the border of the form. In other words, he wants to "flip" the combobox right-to-left.

Unfortunately, I don't know of any way to accomplish this.

Linq ;0>

Your understanding of what I am trying to accomplish is right-on. Hopefully, someone can come up with a solution...thanks all for the effort!
Sep 16 '08 #6

Expert Mod 2.5K+
P: 2,545
It can't be done using an Access combo - which is what Linq mentioned in saying he knew of no way to accomplish it.

-Stewart
Sep 16 '08 #7

NeoPa
Expert Mod 15k+
P: 31,343
As far as I understand it, this only happens when the Width property is less than the List Width property. As I thought I'd made clear in post #2, this can be tidied up by managing these three properties (The last being Column Widths).

If you are still having problems, please post in the values you're using for these three properties and we'll see if we can manage to resolve this for you.
Sep 16 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.