syntax for changing column width in combobox properties

[ntambomvu]

Hello Chaps


I am using steve bishop's video tutorials in you tube.


I am at a lecture that requires to change the column width to 0,1


I am working in mm and I cant get the system to accept 0,1 like steve says.
it changes the entry to 0.101cm as soon as I press enter.


what is the correct syntax for entering the width >


second how and where do I find if access is correctly formatted to mm instead of inches.
regards


fred

 

[The_Doc_Man]

Access is ALWAYS formatted in TWIPS which is a unit of length. The conversion is that 1440 twips = 1 inch.

When you try to set a length in a column-width situation, you can use 1.5" (meaning inches) or 6.2 cm (of course meaning cm). I think you can also use 1.5 in for inches. However, Access will determine the exact width that it can set by converting this to twips and then dropping any fractional twips resulting from the computation. If you then look at the properties again, if this twips-rounding occurred, the number will be re-displayed in your units but using some strange-looking fraction. Which appears to be your complaint.

If I recall correctly, Access will take the width fractions out to four places when it displays the width in inches. I've not used centimeter width before, since in the USA we design things around the foot/inch system.

As to your second question: The database formatting is derived from the Windows Regional settings for numbers. It is not an Access setting but a Windows setting (that is used by all Office programs.)

 

[ntambomvu]

Thank you Doc man for your information on twips


However i found that there was a simple problem which I resolved.
In the tutorial I misread the Quotes symbol (") as an "open quotes"
when in fact it was referring to the abbreviation for inches (")


so problem solved by saying 0.0mm,10mm-- instead of 0",10"


we english should be taught american instead of english (ha,ha)
regards fred

 

[Uncle Gizmo]

A lot of us English are conversant with both!

Sent from my SM-G925F using Tapatalk

 

[The_Doc_Man]

And, unfortunately (based on some posts I have seen on USA forums), many Americans are conversant with neither.