Declaring Public Const - is that forbidden in the declarations section of a form module?

[MLH]

I have a form module that starts out something like this...

Option Compare Database 'Use database order for string comparisons
.....

Then there's a line like this in it...

Public Const MyVar = 0

Clicking Run, Compile gives rise to an error there. Am I not supposed
to use "Public Const" in the declarations section of a form module?

[MGFoster]

MLH wrote:

I have a form module that starts out something like this...

Option Compare Database 'Use database order for string comparisons
....

Then there's a line like this in it...

Public Const MyVar = 0

Clicking Run, Compile gives rise to an error there. Am I not supposed
to use "Public Const" in the declarations section of a form module?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

- From the Access Help topic "Const Statement"

".... In class modules [...] constants can only be private and their
visibility can't be changed using the Public keyword."

Class modules are aka form modules.

- --
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP6qxwYechKqOuFEgEQISEACfc0pmUgpOOcLhLCTuGgk3z+ t8BtMAniYW
OqFYVm95e0KHtdFQywoT/3iN
=g8dS
-----END PGP SIGNATURE-----

[Bill Edwards]

I just tried it in Access 2000 and got the following error message:

"Constants, fixed length strings, arrays, user defined types and declare
statements not allowed as public members of object modules"

Seems self-explanatory.

"MLH" <CR**@NorthState.net> wrote in message
news:jv********************************@4ax.com...

I have a form module that starts out something like this...

Option Compare Database 'Use database order for string comparisons
....

Then there's a line like this in it...

Public Const MyVar = 0

Clicking Run, Compile gives rise to an error there. Am I not supposed
to use "Public Const" in the declarations section of a form module?