Change borders to thick, red

Posted on 2011-10-13
Last Modified: 2012-05-12
I have condition formatting that, dependong on two variables, does change the text within the text control to bold, red.  The user now also wants the BORDERS to be thick, red.  Since the conditional formallting is used - what event would be used to set the borders to these new properties?
Question by:ssmith94015
    LVL 119

    Accepted Solution

    try using the format event of the report section where the textboxes are located

    Author Comment

    Am trying that, but not working
    Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
    'If Due date is with 7 or less days, make the box and data red
        If [TaskDueDate] < Date + 7 And (IsNull([TaskCompletionDate]) Or [TaskCompletionDate] = "") Then
             Me.lblTaskDueDate.BorderColor = RGB(239, 5, 29)
             Me.lblTaskDueDate.BorderWidth = 2
             Me.TaskDueDate.ForeColor = RGB(239, 5, 29)
             Me.TaskDueDate.BorderWidth = 2
        End If
    End Sub

    Open in new window


    Author Closing Comment

    Cap, that was it!  I only needed to add the border style and set it to normal, then it worked.  Thank  you.

    LVL 119

    Expert Comment

    by:Rey Obrero
    can you upload a copy of the db

    Author Comment

    This is a financial institution and all data/applications are proprietary, otherwise I would have no problem.
    LVL 119

    Expert Comment

    by:Rey Obrero
    nevermind, you already made it work..

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now