If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Highlight report line
I need to highlight/shade any lines in a printed report where date 1 = date2,
how do I accomplish this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200912/1 |
#2
|
|||
|
|||
Highlight report line
Conditional Formatting is your friend here. Check the Help for details if
it's not blindingly obvious. You'll need a criteria of {date1] = [date2] in there somewhere; and you'll need to apply it to all the controls in the report section. HTH, Rob PeteN via AccessMonster.com wrote: I need to highlight/shade any lines in a printed report where date 1 = date2, how do I accomplish this? |
#3
|
|||
|
|||
Highlight report line
Select all the controls in the detail line and set their Back Style to
TRANSPARENT. You can select all the textbox and label controls at one time and set the Back style property of all them at the same time. Add VBA code to the detail section's format eventto change the back color of the section depending on the values of the two controls (or fields) Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.ControlA Me.ControlB then Me.Section(acDetail).BackColor = vbWhite else Me.Section(acDetail).BackColor = 13882323 'Light Grey End If End Sub John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County PeteN via AccessMonster.com wrote: I need to highlight/shade any lines in a printed report where date 1 = date2, how do I accomplish this? |
#4
|
|||
|
|||
Highlight report line
Thanks to both John & Rob, this solved my problem.
John Spencer wrote: Select all the controls in the detail line and set their Back Style to TRANSPARENT. You can select all the textbox and label controls at one time and set the Back style property of all them at the same time. Add VBA code to the detail section's format eventto change the back color of the section depending on the values of the two controls (or fields) Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.ControlA Me.ControlB then Me.Section(acDetail).BackColor = vbWhite else Me.Section(acDetail).BackColor = 13882323 'Light Grey End If End Sub John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County I need to highlight/shade any lines in a printed report where date 1 = date2, how do I accomplish this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200912/1 |
Thread Tools | |
Display Modes | |
|
|