Background color box when row clicked on

jonnn21

New Member
Joined
Feb 9, 2012
Messages
21
I apologize for the lame heading but I don't know how to explain it.

I have a table with a name, Red, Green, Blue fields

The Red, Green, Blue fields are the three numbers i'm using to make up the color I want (Blue= 173,192,217)ect...
I have a continuous form that has a single text box. The control source for this textbox is the NAME from that table

The continuous form works great.
All I want to do, is click on a Name and change the background of that SINGLE record to the Red, Green, Blue fields to makes up the single color

Current Code is:
Me.txt_Name.BackColor = RGB(Me.Txt_red, Me.txt_green, Me.Txt_blue)

I have txt_red, txt_green, txt_blue as test boxes (control source to the table of course) as well and those are what is being referred to in the VBA code.
But this changes the color of ALL the records, not just the single record im on.

Suggestions?
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
L

Legacy 456155

Guest
Access question.

The only way I know how do this is using conditional formatting.

VBA Code:
Private Sub Form_Current()
    With txt_Name.FormatConditions
        .Delete
        .Add acFieldHasFocus
        .Item(0).BackColor = RGB(Red, Blue, Green)
    End With
End Sub
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
2,092
Office Version
  1. 365
Platform
  1. Windows
You should be able to do this with the conditional format dialog as well (ribbon) Format> Conditional Formatting. I believe the limit is 3 formats regardless of which method you use.
On a continuous form, there is only 1 "textbox1" - what you see are multiple instances of it, so anything you do to it outside of cf will be applied to all instances of it. As for data, if not bound and you make one contain "cat" they all will.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,033
Messages
5,639,654
Members
417,102
Latest member
bcselect

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top