How to Change Background Color of Specific Records in Continuous F

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have: A continuous form with a checkbox in each record.

I want: The background color of the record to change, depending on the value
of the checkbox (False = White, True = Red).

Any suggestions?
 
I have: A continuous form with a checkbox in each record.

I want: The background color of the record to change, depending on the value
of the checkbox (False = White, True = Red).

Any suggestions?
Click to expand...

Select each control that you wish to change the back color on.
Click on Format + Conditional Formatting

Set Condition1 to
Expression is
write in the next box
[CheckControlName] = -1

Select the Red back color.
Save the changes.
 
fredg said:
I have: A continuous form with a checkbox in each record.

I want: The background color of the record to change, depending on the value
of the checkbox (False = White, True = Red).

Any suggestions?
Click to expand...

Select each control that you wish to change the back color on.
Click on Format + Conditional Formatting

Set Condition1 to
Expression is
write in the next box
[CheckControlName] = -1

Select the Red back color.
Save the changes.
Click to expand...

Is there a way to format the record background (not the control background)?
I tried the code below, but this changes the background of all records on the
form. I want to change the background color of only the records where the
checkbox is checked.

If TRShade.value = True Then
Me.Detail.BackColor = 12632256
Else
Me.Detail.BackColor = 16777215
End If
 
fredg said:
I have: A continuous form with a checkbox in each record.

I want: The background color of the record to change, depending on the value
of the checkbox (False = White, True = Red).

Any suggestions?
Click to expand...

Select each control that you wish to change the back color on.
Click on Format + Conditional Formatting

Set Condition1 to
Expression is
write in the next box
[CheckControlName] = -1

Select the Red back color.
Save the changes.
Click to expand...

Is there a way to format the record background (not the control background)?
I tried the code below, but this changes the background of all records on the
form. I want to change the background color of only the records where the
checkbox is checked.

If TRShade.value = True Then
Me.Detail.BackColor = 12632256
Else
Me.Detail.BackColor = 16777215
End If
Click to expand...

You wish to conditionally change a continuous form's Detail section
color?
You can't, but you can fake it.

Add an unbound text control to the detail section. Size it to cover
the entire detail section and all controls in it.
Delete it's attached label.
Select this new control.
Set it's BackStyle property to Normal.
Click on Format + Send to Back.
While it's still selected, click on Format + Conditional Formatting
Set Condition1 to
Expression Is
Write
[CheckControlName] = -1
in the dialog box.
Select the back color.
Save the changes.

The above will change just the appearance of the detail back color,
not the individual controls within the detail section.
If you also wish to change the individual controls, follow my previous
post suggestion as well.
 
Back
Top