Declare a varable for the entire database

[apank]

I am trying to declare a maximum # of characters that can be inputted into multiple Memo fields. I have a len counter displaying the # of characters.

When the count gets to 10 lets say I want a msgbox to pop up. This is working. Instead of saying:

if lencounter >10 then
Msgbox "You have reached the maxium # of characters"

I would like to set the maximum # of characters once globally so my code would read.

if lencounter >MaxChar then
Msgbox "You have reached the maxium # of characters"

And I would declare the following:

Dim MaxChar as integer
MaxChar = 10

[RuralGuy]

That is done in a standard module (not a form module) before any procedures. You could also use a constant. The Help system can assist you here.

[ADezii]

As indicated by RuralGuy, in a Standard Code Module:

Public Const conMAX_NUM_OF_CHARACTERS As Integer = 10