Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi!

    I have a report that when it loads I would like results to change color based on the value. So if [1] > 25 then the color of [1] would be red adn it would be bold. Is this possible and if so what the code look like? Would I put it on the load event of the report or in each different control on the report?

    Thanks!
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can use conditional formatting:
    - Open the report in design view.
    - Select one or more text boxes and/or combo boxes.
    - Select Format | Conditional formatting... (in Access 2000-2003) or activate the Format tab of the ribbon and click Conditional in the Font group (in Access 2007 and later).
    - You can specify a condition on the value of the control, or an expression (i.e. a formula), and formatting to be applied if the condition is true.
    No code needed!

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    If you don't want to use conditional formatting, you might want to look at setting properties on the On Format Events,
    of the Report Sections
    Andrew

  4. #4
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    OMG!!! That was simply too easy! I love it!

    BTW, I didn't get an email for either of these two responses. They aren't in my spam either.

    Thanks!
    Leesha

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Quote Originally Posted by Leesha View Post
    BTW, I didn't get an email for either of these two responses. They aren't in my spam either.
    Notifications appear to be broken again; it has already been reported in the Feedback to Admins forum.

Posting Permissions

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