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 ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.