Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, February 26, 2008 – Permalink –

Set Field Defaults

Speed up table creation with default field settings



When you add fields to a table, Access assumes you want to use a 50/255-character Text field by default. However, you may typically use a smaller field size or you may personally use Number fields more often than Text ones.


You can avoid having to change the size and data types for new fields by setting defaults that are appropriate to your own design habits. To do so:

  1. Choose Tools> Options from the menu bar and switch to the Tables/Queries sheet.

  2. Select the data type you use most from the Default Field Type dropdown list.

  3. Set the Text and Number sizes you usually want to use in the Default Field Sizes panel and

  4. Click OK.


In Access 2007 go to Access Options>Object Designers:





See all Topics

Labels:


<Doug Klippert@ 6:38 AM

Comments: Post a Comment

Links to this post:

Create a Link