object-naming rules

A set of specific rules for naming Microsoft Access objects. In Microsoft Access, names can be up to 64 characters long and can include any combination of letters, numbers, spaces, and special characters except a period (.), an exclamation point (!), an accent grave (`), and brackets ([ ]). Note that you also can't use leading spaces or control characters (ASCII values 0 to 31). For information on Visual Basic naming conventions, search the Help index for "naming conventions."

Tips

• Avoid including spaces in object names if you'll frequently refer to the objects in expressions or Visual Basic code.
• Avoid using extremely long names because they are difficult to remember and refer to.