How to change column width and have Access accept it?
I've changed the column width of a table field to 20.375, but Access keeps changing it to 20.3796. How to specify the column width I want and have Access not change it?
ASKER
No, it's a table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Barbara
this is the first time I've heard about <column width of a table field > ..
so a visual of your db will definitely help.. upload a copy of your db.
are you referring to a lookup property of a field in a table?
this is the first time I've heard about <column width of a table field > ..
so a visual of your db will definitely help.. upload a copy of your db.
are you referring to a lookup property of a field in a table?
ASKER
Jeff,
I see what you're saying. When I opened your table and changed the column width to 20.375, Access changed it to 20.3796, so maybe it's an issue on my computer. Thanks for your assistance.
I see what you're saying. When I opened your table and changed the column width to 20.375, Access changed it to 20.3796, so maybe it's an issue on my computer. Thanks for your assistance.
Nothing to do about it. It is a rounding issue.
Width is stored in twips, and that is converted to inches or centimeters in the user interface.
/gustav
Width is stored in twips, and that is converted to inches or centimeters in the user interface.
/gustav
ok. my apology.. I see what you meant, in A2010.
I never really make any use of these table properties in my applications, for the simple reason that I never expose any of the tables to the users, in all applications I created.
Records/data are viewed/entered/edited using Forms/ reports never, never from the tables.
I never really make any use of these table properties in my applications, for the simple reason that I never expose any of the tables to the users, in all applications I created.
Records/data are viewed/entered/edited using Forms/ reports never, never from the tables.
The behaviour exists for datasheetviews as well.
/gustav
/gustav
>I've changed the column width of a table field to 20.375
fyi Access (or SQL, or Oracle, ...) tables are not optimized to cosmetically display data, only to store data in certain formats and constraints.
Forms are optimized to cosmetically display data.
So if you really really really need to view a column with a 20.375 inch width, I recommend building a form with a control this wide, and viewing the form instead of the table.
fyi Access (or SQL, or Oracle, ...) tables are not optimized to cosmetically display data, only to store data in certain formats and constraints.
Forms are optimized to cosmetically display data.
So if you really really really need to view a column with a 20.375 inch width, I recommend building a form with a control this wide, and viewing the form instead of the table.
a visual of your form will help, upload a copy of the db