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?