Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    7

    Unanswered: How to make a Label Appear/Disappear based on Date

    Hello!

    Is it possible to display a label on a form only when a date listed within a current record is < todays date otherwise the Label would not be visible. For instance:

    A Warranty Exp Date within a record is dated as 06/01/2006...The user would see the "Out Of Warranty" label, otherwise if the Warranty Exp Date is >= todays date then the user would not see the "Out Of Warranty" label..

    Maybe something like: On_Current

    If Me.WarrantyExpDate < Date then Me.OOW.Visible = True <--------------- (Totally guessing here)
    somekind of statement to make it false...

    Also is it possible to make the Label Flash?

    Thanks!

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    You're on the right track.

    You'll need Else: Me.OOW.Visible = false

    Check out the timer to make it 'flash'. http://www.mvps.org/access/forms/frm0020.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •