Training Support Pack & OOP

Slight rewording of my second question...

I would like to create a class and populate a collection of objects as instances of this class from a database as we did on the course.

However some of the fields returned by the query I am using contain NULLS so I was wondering how this would be dealt with by VBA? Can I still assign these fields to a property of the class? When I access them will these properties then contain NULL or the empty string "" or does this cause an error? Or as I was thinking in my first post, can I set a property as optional and it could return EMTPY when I try to access them?

Hope this is a clearer explanation of what I would like to do.

Many thanks

Craig