I looked through the other thread. I have to say I'm puzzled that a naming
convention would sort of cheapen the program in the view of some. I'm not
clear if those who think poorly of using prefixes for objects would prefer
no naming convention at all, or what exactly, but in any case it seems in
rather a different category than lookup fields in tables.
When I first started learning about Access I was taught to put prefixes onto
fields (txt for a Text field, dat for Date/Time, and like that), but I soon
discovered that I much prefer to use prefixes for controls in particular. I
also use them prefixes objects, so I therefore know that if it does not have
a prefix it is a field. Works for me, even if it offends some.
Best regards.

"Robert Morley" wrote in message
...
Because my professional pride hates being insulted by being called an
amateur even more than I hate being drawn into pointless debates.


Rob

"BruceM" wrote in message
...
If the debates are pointless, why are you adding to them? Name things as
you choose. For myself it would be confusing if account-related tables,
queries, forms, and reports all start with the same prefix, but that's
just my preference.