Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 578
  • Last Modified:

Sending a Box to the Back in Reports

 

I want to highlight an entire record on my report. I don't want to just change the color of the text box background.  I want to highlight the entire row.  The only I can think of doing this is to create a rectangle box that goes across the entire report.  Then create my Conditional Formatting to change the color of the entire box.  

My question is how can I bring my text boxes to the front or send the rectangle box to the rear.   Right now the text boxes are hidden behind the rectangle box.  I've tried something like this but I get errors.  It won't allow me to setfocus on a report:


Private Sub Report_Open(Cancel As Integer)
    Me.Box.SetFocus
    DoCmd.RunCommand acCmdSendToBack
End Sub
0
gfortuna
Asked:
gfortuna
1 Solution
 
Rey Obrero (Capricorn1)Commented:
you can only do that in design mode

select the rectangle then in the Access menu Format>Send to back
0
 
gfortunaAuthor Commented:
I was definitely over thinking that one.  Thanks for you help capricorn!
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

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