Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Sunday, March 25, 2018 – Permalink –

Srt Fields 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:

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

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

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

Click OK.

In Access 2007+ go to Access Options>Object Designers:

See all Topics access
Labels: Functions, General, Reference, Tips, Tutorials

<Doug Klippert@ 3:10 AM

Comments: Post a Comment