Clearify Class Modules and Custom Functions (1 Viewer)

[Galaxiom]

I don't see the point of creating a Class Module just to hold some public functions. All you would be doing is making it necessary to instantiate an instance of the Class.

Public functions belong in a Standard Module.

 

[Galaxiom]

not sure why you are using VBA.

I agree. Why write a VBA function to remove double spaces when exactly the same process can be done far more efficiently in SQL?