Help Please - Labels

[graviz]

I have a form with a bunch of labels I'm trying to make a custom status bar. All are set to visable = False in the properties window. After the user presses the button it runs a bunch of code from a standalone module. When it gets to certain parts of the code, I would like the labels to become visable = true. I did some reading & searching but the code is not working. Here's what I'm using to make this happen

Me.lbl1.visable = True

I figured this could only be used in it's in the form's modules and not a standalone. Is there a way to make this happen in a standalone module?

Thanks

 

[vbaInet]

Forms!NameOfForm!lbl1.visible = True

Or

Forms("NameOfForm")lbl1.visible = True

Or

Forms("NameOfForm").Controls("lbl1").visible = True

There are other variations too, a mixture of 1 and 3.

 

[graviz]

I tried the first way and I'm getting this error.

"Object doesn't support this property or method"

Forms!Main!lbl1.visable = True

Any ideas?

 

[graviz]

I tried the first way and I'm getting this error.

"Object doesn't support this property or method"

Forms!Main!lbl1.visable = True

Any ideas?

Haha I guess you have to spell visible right.

 

[vbaInet]

haha! and i spelt it wrong too lol. All working now?

 

[graviz]

haha! and i spelt it wrong too lol. All working now?

Yes the only issue is it's not displaying them as they go through the code. It displays 2/10, then 10/10. Not as the code is going.

 

[vbaInet]

I don't understand. What is 2/10? I don't know what your code looks like or what it does.