Comboboxes and regional settings

[m0use]

Hi, I have a problem with regional settings and programming the ColumnWidths of a Combo Box. I already posted this thread at the Forms forum however no-one there seems to know the solution to this challenge:

My challenge:
The company I work for is located in Europe and normally set the regional settings of Windows to the Metric system. However, users in the UK use Inches instead of Centimeters. In my database i program comboboxes to show a centain number of rows by manipulating the ColumnWidths property.
But when you set the value to: "1,5 cm; 0 cm; 1 cm" it won't work on a machine that uses Inches. Is there a way to check which regional settings a machine has? Then i can use that to fill the property with the right values.
Help would be much appreciated. Help wil be much appreciated, m0use.

 

[ColinEssex]

I thought the regional settings for measurement was either Metric or US System.

Col

 

[m0use]

I thought the regional settings for measurement was either Metric or US System.

Col

I want my database to recognize which regional settings are set on the machine it runs on. That way I can programmatically change from Inches to Centimeteres or the other way around. Otherwise every user of the database has to have the same regional settings.

 

[ChrisO]

To avoid the need to check the regional settings you can set the widths to twips as in: -

Me.cboMyCombo.ColumnWidths = "0, 2880, 1440, 1440"

This set four columns to 0; 2; 1; 1 inches.

Hope that helps.

Regards,
Chris.

 

[m0use]

To avoid the need to check the regional settings you can set the widths to twips as in: -

Me.cboMyCombo.ColumnWidths = "0, 2880, 1440, 1440"

This set four columns to 0; 2; 1; 1 inches.

Hope that helps.

Regards,
Chris.

Thank you Chris, this solves my problem.