• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • 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
Sandra Smith
Asked:
Sandra Smith
  • 3
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try using the format event of the report section where the textboxes are located
0
 
Sandra SmithRetiredAuthor 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
 
Sandra SmithRetiredAuthor 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Rey Obrero (Capricorn1)Commented:
can you upload a copy of the db
0
 
Sandra SmithRetiredAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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