• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Change borders to thick, red

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?
0
ssmith94015
Asked:
ssmith94015
  • 3
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try using the format event of the report section where the textboxes are located
0
 
ssmith94015Author Commented:
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

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

Sandra
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rey Obrero (Capricorn1)Commented:
can you upload a copy of the db
0
 
ssmith94015Author Commented:
This is a financial institution and all data/applications are proprietary, otherwise I would have no problem.
0
 
Rey Obrero (Capricorn1)Commented:
nevermind, you already made it work..
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now