Table Defaults

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

Hope somebody can help me !

I am about to create a database with tables that are going
to use the format of ....

Field Name.....NEThing
Data Type .... Number
Field Size.....Long Integer
Format....Fixed
Decimal Places ...2

Is there a default in Access that I can change so I don't
have to go into every field name's properties and change
this manually....For example when I have created my field
name, and changed the data type to Number, it
automatically sets the other options I have chose above ?
Or am I just going to have to copy and paste then change
my field name ?

Thanks for anyhelp on this that you can give me
 
John, I think "copy, paste and change the field name" is about the best
you're going to do to speed up creating fields in a table's design. In
Tools|Options|TablesQueries, you can set the default Text field length and
Number size but that is about all.

By the way, in your description of your number field, I noticed that you
have a Long field size with 2 decimal places. Although you *can* set the
Decimal property to 2 and get the field to display decimal places in the
table, a Long will not store decimal values - only whole numbers. To store
fractions, you would need to use Decimal, Single or Double as your number
Field Size.

hth,
 
Hi Cheryl

thanks for the reply - its appreciated. Looks like I will
stick to copying and pasting !!

Worth an ask tho I guess!
 
Back
Top