O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Assigning Field Properties

Field properties are crucial to maintaining and enhancing data integrity and presentation. The properties you set in the lower pane of the Design window dramatically affect the way data is used and displayed in forms, queries, and reports. These objects inherit the field properties from the underlying table.

Some field properties can be set within these other objects, and they may (or may not ) override the settings in the table (I'll leave most of that discussion for Chapter 6, “Entering, Editing, and Displaying Data”). Nevertheless, it will simplify your life greatly if, for the most part, you set field properties just once in tables and let them be.

Instead of wasting a lot of paper giving you all the specifications ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required