Enum in access97

[citychap26]

Hi

I have not programmed in Access 97 for a few years, can you not create your own Enums ? IE

Public Enum Blah
val1 = 1
val2 = 2
End Enum

Cheers

Sunil

 

[RickSpr]

Enum was introduced in VBA6, which was first used in Access 2000. In Access 97 you have to use Const declarations.

If you're trying to define an Enum type in a class module, substituting Const declarations won't work for use outside the class, because Public Const isn't allowed in a class module. Your class will have to have a companion standard module containing the Const declarations.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein