Changing text box back colour

[Duncan]

G-day


New to access and recently developed a successful database for work analysing KPI results etc. Now just for a learning experience re: analysing LOTTO results, I want to develop a form to changes the back colour of a text box when the number in it is the same as one entered in another text box (so I have a static unchanging 18 rows of 6 numbers in each in a table and one row of six numbers that change each week depending on the LOTTO draw and are entered in via text boxes on the form]. I can do this with;

Dim Num1 As Long
Num1 = Me.No1 (No1 = first weekly drawn number)
If Me.n1 = Num1 Then (n1 = column one of the 18 rows)
n1.BackColor = vbGreen
End If

My lotto card is 18 lines long and I have used a continuous form to have all the 18 lines load into the form from a table. So when I put the first drawn number into Me.No1 text box and if it matches the first number in the first row of Me.n1 text box the whole 18 rows change colour instead of only the ones that match Me.No1. Any help would be welcome.

[Missinglinq]

I'm having a little trouble following your explanation, but when you change the Formatting of a Control in one Record, on a Continuous View Form, you're Formatting that Control in all Records! That's how Continuous View Forms work...unless...you use Conditional Formatting off of the Menu/Ribbon!

In Form Design View

1. Right-Click on the Control to be Formatted
2. Click on Conditional Formatting
3. Going thru the boxes, from Left-to-Right
4. Under Condition1 select Expression Is
5. In the 'conditions box' to the right, enter [n1] = [Num1]
6. Use the icons to set your Formatting (the 'paint bucket' controls the Back Color)
7. Click on OK

Note that the Square Brackets around the Control names are mandatory, in Conditional Formatting.

Now only the Control on the matching Record should change color, if I understand you correctly.

[Duncan]

Excellent works like a charm. And to think I spend a few hrs on a Saturday night using VB to figer it out. I did attemt to use Conditional Formatting in the first instance but it did not work.

[Missinglinq]

Glad we could help!

Linq ;0)>