Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Backcolor In a Field (Access 2000)

    I'm trying to change the backcolor of my Payment field to red only if the NSFWarnings box is checked, otherwise the backcolor should stay white. But I'm not really sure how to do this. I've read the posts on backcolor, but I'm still confused. I guess it's because I'm not sure how to refer to the backcolor property of a form I don't have open.

    I'm in a form called ProcessNSF. When I click that button I want to process my NSF I selected, and have the Payment field be red in the Payments form. How do I tell it to do that?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changing Backcolor In a Field (Access 2000)

    I don't see the point of changing the background color of a text box in a form that isn't open. The user can't see it!

    Is NSFWarnings also part of the record source of the Payments form? If so, you can use Conditional Formatting:

    - Open the Payments form in design view.
    - Select the Payment control.
    - Select Format | Conditional Formatting.
    - Leave the first section (Default Formatting) unchanged.
    - In the second section (Condition 1), select Expression Is from the dropdown list.
    - In the box next to the dropdown list, enter [NSFWarnings] = True
    - Click the paint bucket to select the background color.
    - Click OK.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Backcolor In a Field (Access 2000)

    I wanted to change the color so that when I do open the Payments form, it's red--you can then tell why the payment went to zero (it's NSF). I'll try what you suggested.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Backcolor In a Field (Access 2000)

    It seems to have worked fine! Thanks, Hans!

Posting Permissions

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