<div>
Am trying that, but not working<br />

<pre><code id="code-8226747">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] &lt; Date + 7 And (IsNull([TaskCompletionDate]) Or [TaskCompletionDate] = &quot;&quot;) 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</code></pre>
</div>


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

<div>
Cap, that was it! &nbsp;I only needed to add the border style and set it to normal, then it worked. &nbsp;Thank &nbsp;you.<br />
<br />
Sandra
</div>


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

Sandra

<div>
can you upload a copy of the db
</div>


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


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

<div>
nevermind, you already made it work..
</div>


<div>
<div class="content wysiwyg-content">
I have condition formatting that, dependong on two variables, does change the text within the text control to bold, red. &nbsp;The user now also wants the BORDERS to be thick, red. &nbsp;Since the conditional formallting is used - what event would be used to set the borders to these new properties?
</div>
</div>


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?

Change borders to thick, red

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.