Access listbox multiple columns don't align with my labels

I have a multicolumn list box with a colum count of 7. I have 7 labels on top of the listbox. This is so I can click a label and invoke a function to sort on that field. My issue is I can not seem to get the label widths to be the same as the coulm widths.
Say the 1st column width is .0648 I try to change the first label width to .0648 when I hit enter it changes to .0647. This is happening to all the labels and also if I try to make the column width the same size as the label after I hit the enter key it will change it to a different number.
Any one have any idea or know of any web page that addresses this?

Thanks!
Chuck LoweAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
Try setting it to 0.649 or 0.650.

/gustav
Jeffrey CoachmanMIS LiasonCommented:
I think Access is rounding the the next smallest increment it can support.

Odd, ...but for me (in the U.S.)
 .0648 is rounded to:  .0646

...are these fractions of an inch really making a significant difference?

Also let's be clear, you are adding your own "headers" (as labels)?
Please note that a List box has a "Column Heads" property (displays column headings), that is typically turned OFF.

If you turn this property ON, you will get field names that will resize with the width you set for the column...

JeffCoachman
Chuck LoweAuthor Commented:
@Gustav
It's happening with the majority of all the labels and column widths for the multi columns.
For the label I changed it from .0647 to .0648 went back to .0647. I tried .0649 went back to .0647. I tried .0650 went back to .0647.  If i change it to .0655 it takes the setting. But when I change the width on the multi column it wont stay the same. It's working the same way the label width is working.
It's very frustrating. Why won't it keep my column settings?
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Chuck LoweAuthor Commented:
@Jeff
YES. I am adding my own headings as labels. As stated, so when I click on them I can invoke a function to sort the list. The column head property is turned off.
I don't know what to tell you it's rounding as I stated.
As for making a difference it does when there are 7 items in the list. The lines get greater out of proportion as the list goes on. If I make some smaller it still is out of wack.
Chuck LoweAuthor Commented:
@All
Could it be a PC setting? Can I make the widths CM or something like that?
Gustav BrockCIOCommented:
It's because the value you see is rounded to inches or centimeters from twips. So when you enter a value, it is first rounded to the nearest usable value in twips, then converted back.
This often creates a shift of the smallest decimal.

The only solution is to find a value to enter that either sticks or will be converted to a value you can use.

/gustav
Jeffrey CoachmanMIS LiasonCommented:
FWIW,...
What I have done in the past was to turn on the column headings, ...and add a "small" button (that actually displayed the sort status) above the headings, to do the sorting.
In this way, small changes in the column width had less of an effect on the overall appearance...
12
Chuck LoweAuthor Commented:
@Gustav
That's going to take a while. My issue is it's different between the Label and the cooresponding multi column. The values don't stay consistent.
@Jeffrey
I had a similar idea. Due to real estate and mostly company programming standards I can't do that.

Thanks!
Chuck LoweAuthor Commented:
@All
I had to painstakingly make sure the label field lengths and the multirow lengths were in sync. Then I had to add the field lengths of each label to the left starting to get the next left starting for that label. It almost is perfect but good enough for the users

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chuck LoweAuthor Commented:
I accepted my own solution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.