troubleshooting Question

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

Avatar of wsturdev
wsturdevFlag for United States of America asked on
Microsoft Access
2 Comments1 Solution337 ViewsLast Modified:
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?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros