Appendix B. Naming Conventions

This appendix gives you suggestions for naming variables and other database objects. The suggested standards are based on the Reddick VBA Naming Conventions (RVBA).

When creating variable names, it’s important to make the type and intended use of each variable clear and self-documenting. Here are a few rules to follow:

  1. Remember to always make variable names mixed case, with each word or abbreviation in the variable name capitalized.

  2. Don’t use underscore characters in your variable names.

  3. Abbreviate variable names only when it’s necessary.

  4. Make the beginning of each variable name describe the type of data it contains.

Following these conventions will go a long way toward keeping your code concise and readable. The format ...

Get Alison Balter’s Mastering Microsoft Access 2002 Desktop Development 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.