what does gcf in gcfDebugMode stand for? global constant.... f stands for?

oh whao! i didn't know about f being a boolean.

i always used booSomething.

i'm going through Total Visual CodeTools now.

my golly so many things i need to standardise and change to write better code. quite disappointed with my skills now but i will improve. every admission is the start of a big improvement = )

thanks DatabaseMX! = )

Well, I use one letter as a prefix (less is more).
So, b  for Byte, l for Long, i for  Integer, etc. Ended up f for Boolean - not my original however. Not sure where I saw it first.

mx

The idea behind the prefix is to make it clear when you look at code to understand the scope of the variables without having to look at the definition of each one. Over time, it becomes hard to understand without them. Fortunately, Total Access CodeTools lets you apply these prefixes for you. Of course, you want to make sure Option Explicit is defined in each module and your code compiles before making variable name modifications.

The letters are naming conventions that may not make the most sense but generally accepted.

"g" for variables/constants defined as Public
"m" for module level (private in declarations section)
"p" for parameters
"a" for arrays

"f" for flag/boolean -- and I agree this makes little sense for VBA

and generally three letters for other variable types

Hope this helps.

Yup it does, thanks Luke!!