Results 1 to 5 of 5
  1. #1
    graviz is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    48

    Help Please - Programming Labels

    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

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    If you want to do this outside of the form where the labels are you need to reference the form like this:

    Forms!MyForm!lbl1.visible = True

    Substitue the MyForm bit with the name of the form that the label is on.

  3. #3
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    You need to check the spelling of visible. you have written visable.

  4. #4
    graviz is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    48
    Quote Originally Posted by maximus View Post
    You need to check the spelling of visible. you have written visable.
    Haha thanks, I knew it had to be something simple like that. Everytime I tried something new I just copied and pasted so it was always wrong just because I mistyped the first time. Thanks again

  5. #5
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    ha!ha! I have 8yrs of debugging scripts thats why I tend to look at scripts minutely. Glad that I could help you out.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Labels
    By MFS in forum Programming
    Replies: 2
    Last Post: 01-28-2010, 07:01 AM
  2. Replies: 22
    Last Post: 08-30-2009, 02:15 PM
  3. Positioning Tabular Labels
    By rod147 in forum Forms
    Replies: 6
    Last Post: 07-06-2009, 11:02 AM
  4. Replies: 1
    Last Post: 05-27-2006, 12:35 PM
  5. cannot print labels
    By Diane in forum Database Design
    Replies: 4
    Last Post: 12-29-2005, 08:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums