Listbox column width vs Combobox column widths : Discrepancy

[ironfelix717]

Hi,



I am a bit confused with this one.

I threw together a quick homemade pivot table for this project which uses a listbox and some combo headers to control the rowsource.
(theres probably an easier way/control to use - feel free to recommend (prefer an unbound solution))

Anyway, there are combo boxes aligned,sized, and spaced above the listbox to change the field of interest.

Its probably best at this point to look at the images attached to understand my issue:

Notice the comboboxes don't align with the columns in the listbox.

The positioning + widths are all controlled via code at runtime.

The fact that they don't align makes no sense here: the listbox columns are set to 1". The comboboxes are set to 1" widths and they are all aligned left of eachother.

Yet there is an error occurring somewhere in the alignment to the listbox and I'm out of thoughts.

See attached!
Any ideas?


Regards

[Micron]

Your post says combo column width but to control the width of a combo itself, the property you want to alter is the control width, not the column width. Column width property affects how wide the list is when you drop it down.

[ironfelix717]

Your post says combo column width but to control the width of a combo itself, the property you want to alter is the control width, not the column width. Column width property affects how wide the list is when you drop it down.

Yes that is a mistake.Admin should change the name to Listbox column width vs Combobox control width: Discrepancy

You can see in the images what i am trying to achieve. There is an error between the column width of the listbox versus the CONTROL width of the comboboxes.

Either this is a bug in Access or i am missing something.

[Micron]

Don't know what to tell you except that whatever you're doing in code must be where the problem lies, or perhaps you have a property set in design that is interfering. I was thinking of padding, but IIRC, that only affects text alignment, not control alignment. Works for me just using design and not code:


EDIT - unless the extra .1979" you have in the listbox is the cause, but I'm thinking that just gets added to the last column as extra space. Why have 12 1" columns but a control width of 12.1979"?

[ironfelix717]

Micron,

the .1979 difference in Listbox control width solved the issue.

I guess i gave Access too much credit - figured it would logically automatically put any difference at the end of the listbox (last column).

Thanks for noticing that.

[Micron]

Maybe it would if everything was done in design view. Sometimes code manipulation of objects isn't applied the same as if done in design but I can't recall which properties I've read about that behave that way. I suppose a test would be to replicate the design only via the property sheet and see what Access does with the extra width.
Glad you got it solved!