We help IT Professionals succeed at work.
Get Started

URGENT -- How to dynamically set column widths for International usage

wsturdev asked
Last Modified: 2013-11-27
I have an Urgent issue.  I have an Access 2007 application.  So far, it has been run only in North America.  But now I need to have a user run it in Germany.

I have the following code:
                Me.myComboBox.ColumnWidths = "0,3.75 in,.75 in,1.25 in"
It fails on my German user's machine with a message saying it cannot recognize the inches notation.

So I changed it to Twips:
                Me.myComboBox.ColumnWidths = "0,5400,1080,1800"
And it still fails on my German user's machine.

I also tried centimeters -- same error.

His regional settings for "Measurement Settings" is Metric, so I would have thought centimeters or twips would work, but got no where.

What can I do?  And if it involves dynamically finding out what my user's regional settings are and then executing different code, how do I read my user's regional settings?
Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE