Results 1 to 5 of 5

Thread: Form (2002)

  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Texas
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form (2002)

    Is there a way to change the Back Color of just one row based on a value in one of the fields in that row leaving the remaining field Back Color on all other rows unchanged?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form (2002)

    In a form or query or data sheet NO
    In a report you can use this in the on format event of the detail:

    If put here your condition Then
    Me.Detail1.BackColor = vbRed
    Else
    Me.Detail1.BackColor = vbWhite
    End If

    To have to most impact, set the Back Style of the textboxes to Transparent.
    Francois

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Form (2002)

    It is possible to do it on a form, but it is not easy. Follow the link below to my website and download Highlite.mdb; it is an Access97 database that illustrates how it can be done.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Form (2002)

    It is possible to do it on a form, but it requires some work (and it has some drawbacks). If you have a chance, pull down Highlite.mdb from my website, I think you'll be intrigued.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form (2002)

    Take a look at this thread
    The demo I posted there illustrates another way of doing what you want.
    HTH
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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