Make a label appear for only a few seconds

Posted on 2012-09-01
Last Modified: 2012-09-01
Is there a way to make a label appear for only a few seconds.
If so anyone's help on this would be greatly appreciated
Question by:jleval
    LVL 77

    Expert Comment

    To make a label on a form disappear after say 5 seconds, set the form TimerInterval property to 5000 and in the Form Timer event procedure do..

    Me.yourlabelname.visible = false
    me.timerinterval = 0 ' switch off timer
    LVL 56

    Accepted Solution

    or use a routine like the one below.  Paste it into a module, then do:

    Me.<myLabelcontrol>.Visible = True
    Me.<myLabelcontrol>.Visible = False

    If you're looking to have a generic message box, see the attached DB.


    Public Function Wait(intSeconds As Integer) As Integer

            Dim datCurDateTime As Date
    10      datCurDateTime = Now

    20      Do Until DateDiff("s", datCurDateTime, Now) > intSeconds
    30        DoEvents
    40      Loop

    End Function
    LVL 30

    Expert Comment

    "Is there a way to make a label appear for only a few seconds. "

    First check above comments if any answer your question.

    If not resolved then:

    You did not clearly specify when to start counting  the few seconds?
    How you do make it visible in the first place?
    Any chance to make it visible again in the same session?

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Day count current month 3 23
    Access 2003, modify export spec 11 14
    Create exported XLS from Query 19 18
    Custom auto number 6 27
    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now