Results 1 to 5 of 5

Thread: Solved: Conditional Format of textbox on form

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Tutor
    Joined
    Dec 2006
    Posts
    271
    Location

    Solved: Conditional Format of textbox on form

    I am trying to get the colour of a text box on a form change colour if the value is less than todays date
    Obviously this doesn't work:

    Private Sub txtActiveto_Change()
        If txtActiveTo.Value = "< Now()" Then
            txtActiveTo.BackColor = &HFF&
        Else
            txtActiveTo.BackColor = &HFFFFFF
        End If
    End Sub
    Anyone point me in the right direction please
    Last edited by Aussiebear; 03-29-2025 at 05:05 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
  •