change default number format in new access tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In MS Access, it is possible to change the dafault format for fields in a
table that you create. However, it is not possible to do the same for tables
that are created from a make-table query. It is unclear why, in this case,
the default isn't simply "double". If a field contains only integers, Access
selects long integer for the format. You then have to manually change the
formatting before you update or append any non-integer values for this field.
This is a royal pain for an automated series of events run from a macro,
short of writing the routine in VBA.

Chance you could fix this?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...bf9d517c88e&dg=microsoft.public.access.macros
 
Greenbeard,

If the field in the table/query that you are using as the basis of the
Make-Table query is a Double field size, then so will the field in the
new table produced. Otherwise, a simple workaround for the scenario you
described is to use a calculated field in your Make-Table query, like
this...
ExportField: [YourIntegerField]/1
This will result in the field in the table produced by the Make-Table
query to be a Double field size.
 
Back
Top