Creating a Password for a form

  • Thread starter Thread starter Revbnc
  • Start date Start date
R

Revbnc

I actually found a MS Article on how to create a password
(#209871) and went through all the steps with no problem
until I had to actually go into the form I wanted to
protect and in the OnOpen property type the password code.

When I put the information in the box I am now getting an
error "An Expression cannot be longer than 2,048
Charactors". I then must delete the code in order to do
anything else.

The code is only around 1,000 charactors including
spaces.

Does anyone have any ideas? Please help!!
 
There is a lot of code in that article. Can you give us a clue as to which
line the error is occurring on?
 
Are you typing the code into the property sheet? I didn't look at the
article but I'm assuming that you should enter an event procedure for the
OnOpen event of the form. To do this you should click inside the OnOpen
field in the form's property sheet and then click on the button with the
elipses that appears to the right of the field. Then select "code builder"
from the dialog that opens up and the vba editor should open. That is where
you should type the code.

If you already knew this, I'm sorry for pointing it out. Your post makes it
sound like you're putting code in the property sheet.
 
Back
Top