Naming Fields

Remember these simple rules when you create field names:

• A field name has to be unique: You can�t have two fields with the same name in the same table.

• A field name can be up to 64 characters long.

• It can include any combination of letters, numbers, spaces, and special characters except as noted below.

1. A field name can�t begin with a space.

2. A field name can�t contain a period (.), an exclamation point (!), an accent grave (`), or either bracket ([ or ]).

Now remember this advice:

• Make your field names descriptive.

• Keep your field names short.

• Don�t use spaces, even though Access says you can.

You�ll appreciate our advice when the time comes to create calculated fields, or to write Visual Basic code.

(Posted 01/01/2001)