I have an Access DB with a many to many relationship which I have separated with a join table. I have also created a query to the join table and built a basic form to allow me to add multiple authors to multiple books.
When I open my form, and try to select the drop down box that provides the author first and last names associated with the autonumber, it will only display the fields visible for the width of the drop down column. The dopped box will not show the three feilds its contain. If I widen the column, the other feilds show up.
Why is this working this way?
For reference, I am using Access 2003 via parallels on a mac
You can set the column widths to be something like
And that will limit the width of each column to whatever you specify. Is this what you're talking about?
I tried setting the width but it did not do the trick. I am actually trying to recreate an example I found online before working it into a DB we use to track companies. The link to the site is (Accommodating a many-to-many relationship in Access) In figure H, you see that the drop down in the sub form has all three columns visible. On my DB, the displayed columns are bound by the width of the AuthorIDFK column, and you need to use the horizontal scroll to move right to see the value in the other columns. Or you can make the AuthoIDFK column ridiculously wide, and it will display the results. Both options are not satisfactory, and I would like to have my drop down in my subform look like that of figure H.
Please let me know if you need any more info from me, and thank you for taking to the time to help me out.
There is a difference between the Width property of a combo (ie. the width it has when it is "closed") and the ListWidth property. That one set the width of the list when you drop down the combo. Both can be totally different.