asked on URGENT -- How to dynamically set column widths for International usage
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
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
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?
I have the following code:
Me.myComboBox.ColumnWidths
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
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?
Microsoft Access
Last Comment
wsturdev
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Me.ColumnWidths="0;1;1;2"
with semicolons ...