Database Prefix Naming Conventions

by Justin Watt
comments gratefully accepted: jwatt [at] email [dot] unc [dot] edu
Last Modified: 10/15/04

database object prefixes

objectprefix
table(none)
formf_
queryq_
reportr_
modulem_
subformsf_
subreportsr_

user-interface control prefixes

controlprefix
text boxtxt_
toggle buttontgl_
option buttonopt_
check boxchk_
combo boxcbo_
list boxlst_
command buttoncmd_

vba datatype prefixes

data typeprefix
stringstr_
integerint_
variantvar_
booleanbln_
datedate_
recordsetrst_