Set Field Properties to Control Data Entry Previous Topic

Previous Page
Next Topic

Next Page
Database Window button Database Window button Save button Save button

Each field in a table has a set of properties that you can customize to determine how data is handled. You can set field properties for a table while working in table design view. To open a table in table design view, click Database Window. On the Tables tab, click the table whose fields you want to customize, and then click Design. When you’re done, click the Save button.

Screenshot shows Products table in table design view.

Important Icon

Important   Set properties for a table before you create forms, reports, or queries based on that table. If you set table properties after creating forms, reports, or queries, some of the settings won’t apply to the forms.

New Object button and arrow New Object button

Tip Icon

Create a form that uses your new property settings   Save the table, click the New Object arrow, and then click AutoForm.

Office Assistant button Office Assistant button

Cross Reference Icon

Want to know more?   Look up Getting Results - Field Properties in Help.


Getting Around | Contents | Index

<< Previous Topic | < Previous Page | Next Page > | Next Topic >>

©1996 Office Getting Results Book.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.