VBA Public variable declaration vs. Global declaration

[Scott2S]

In Access 97, the public declaration of a variable replaces Access 2.0's global variable declaration. Apparently there are subtle differences between public and global variables in Access 97, does anyone know what the differences are? I can't find any information in the help or book about global variables. When I search for global in the help it comes up with public.


I have a converted database with many global declarations and am thinking about converting these to public.

(I posted this same thread over in the Access forum but decided it needed to go here instead)

Thanks in advance

 

[swilliams]

Essentially, a global variable is available to all parts of your application, and dim'ing a variable as public also has this effect. However, there are restrictions in where you can dim things as global / public. IE you cannot declare a public variable in a private module (I think!!).

Generally speaking, you should try and keep your variables as local as possible and try to avoid global / public variables. There are of course situations where a global variable is ideal - such as username / userinitials / ...

Simon