<div>
I've always had to do it like this:<br />
<br />
Me.ColumnWidths=&quot;0;1;1;2&quot;<br />
<br />
with semicolons ...
</div>


I've always had to do it like this:

Me.ColumnWidths="0;1;1;2"

with semicolons ...

<div>
<div class="content wysiwyg-content">
I have an Urgent issue. &nbsp;I have an Access 2007 application. &nbsp;So far, it has been run only in North America. &nbsp;But now I need to have a user run it in Germany.<br />
<br />
I have the following code:<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Me.myComboBox.ColumnWidths<wbr /> = &quot;0,3.75 in,.75 in,1.25 in&quot;<br />
It fails on my German user's machine with a message saying it cannot recognize the inches notation.<br />
<br />
So I changed it to Twips:<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Me.myComboBox.ColumnWidths<wbr /> = &quot;0,5400,1080,1800&quot;<br />
And it still fails on my German user's machine.<br />
<br />
I also tried centimeters -- same error.<br />
<br />
His regional settings for &quot;Measurement Settings&quot; is Metric, so I would have thought centimeters or twips would work, but got no where.<br />
<br />
What can I do? &nbsp;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?<br />

</div>
</div>


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?


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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.