=if order received, Highlithing details section in grey

[Fred's]

Hi Folks,

I've tried to figure out how can I highligt entire specific record row
on a
report, and this by clicking a check box on a form ie: (if order
received, then highligth section detail in grey)
but till now no success. Consequantly, if anyome knows how can I do
that, please help me,


Thanking you in advance for your help!
Fred's

 

[fredg]

Hi Folks,

I've tried to figure out how can I highligt entire specific record row
on a
report, and this by clicking a check box on a form ie: (if order
received, then highligth section detail in grey)
but till now no success. Consequantly, if anyome knows how can I do
that, please help me,

Thanking you in advance for your help!
Fred's

Is the [OrderReceived] field included in the report's recordsource?

If so, then code the Report Detail Format event:

If [OrderReceived] = True Then
Me.Section(0).BackColor = 12632256
Else
Me.Section(0).BackColor = vbWhite
End If

For best results, the BackStyle of each control should be set to
Transparent.

 

[Klatuu]

Well, the only problem is that will make the entire section turn to the
selected color.
It may be better to have all the text boxes in the row touch, then set the
back color property of all the controls on the row. In either case, this
would need to be done for each row.

Put the code in the Format event of the section the rows are in.
--
Dave Hargis, Microsoft Access MVP

Hi Folks,

I've tried to figure out how can I highligt entire specific record row
on a
report, and this by clicking a check box on a form ie: (if order
received, then highligth section detail in grey)
but till now no success. Consequantly, if anyome knows how can I do
that, please help me,

Thanking you in advance for your help!
Fred's

Is the [OrderReceived] field included in the report's recordsource?

If so, then code the Report Detail Format event:

If [OrderReceived] = True Then
Me.Section(0).BackColor = 12632256
Else
Me.Section(0).BackColor = vbWhite
End If

For best results, the BackStyle of each control should be set to
Transparent.

 

[Fred's]

Hi Folks,

I've tried to figure out how can I highligt entire specific record row
on a
report, and this by clicking a check box on a form ie: (if order
received, then highligth section detail in grey)
but till now no success. Consequantly, if anyome knows how can I do
that, please help me,

Thanking you in advance for your help!
Fred's

Is the [OrderReceived] field included in the report's recordsource?

If so, then code the Report Detail Format event:

If [OrderReceived] = True Then
Me.Section(0).BackColor = 12632256
Else
Me.Section(0).BackColor = vbWhite
End If

For best results, the BackStyle of each control should be set to
Transparent.

The [OrderReceived] field is a YES/NO data type and came from my query

 

[fredg]

Well, the only problem is that will make the entire section turn to the
selected color.
It may be better to have all the text boxes in the row touch, then set the
back color property of all the controls on the row. In either case, this
would need to be done for each row.

Put the code in the Format event of the section the rows are in.

David,
It turns the entire section for just that record.
Other records in the detail section will still be in a white detail
back color.
I believe that is what the OP wanted... to turn the detail section
gray for just that record.
If the next record is not [OrderReceived] the code will turn the next
record's detail back to white.

Perhaps we'll be lucky and the OP will let us know.

 

[Klatuu]

hmmmmm, maybe I was wrong, I will have to give that a try to see how it
acts. I was under the assumption it would turn the entire detail section.
As you say, maybe when the OP gets it working, he will let us know how it
really works.
--
Dave Hargis, Microsoft Access MVP

Well, the only problem is that will make the entire section turn to the
selected color.
It may be better to have all the text boxes in the row touch, then set the
back color property of all the controls on the row. In either case, this
would need to be done for each row.

Put the code in the Format event of the section the rows are in.

David,
It turns the entire section for just that record.
Other records in the detail section will still be in a white detail
back color.
I believe that is what the OP wanted... to turn the detail section
gray for just that record.
If the next record is not [OrderReceived] the code will turn the next
record's detail back to white.

Perhaps we'll be lucky and the OP will let us know.