Conditional Formatting not Working unless I Click on Control

[edmscan]

Ok .. so I have a Continuous form that I want a control to have a different background color if it matches a value I enter from a text box.

The thing .. the form loads with NO data. I then .. enter in values in 4 text boxes. This does not change, always the same.

I have a button .. which loads the form with the correct data.
( I just alter the recordsource in the button .. based on the entered 4 values).

But the conditional formatting does not happen .. it stays the same, however if I click on the control with my mouse it DOES change color based on the conditional formatting.

I want the form to be displayed with the conditional formatting once I click the button.

I see lots on conditional formatting .. but nothing that explains my issue.

This is definitely not a conditional formatting issue .. as the conditional formatting does work but needs a mouse click to give it focus I assume, then the control background changes.

Here are a couple of photos that show my issue .. top not working and bottom is the desired result where there is a match.



I had to edit out some customer data .. but you should get the idea. Oh ... and I cannot just query for the data on the radio I entered .. that would be too easy. The other data is needed for time stamp purposes.

[ssanfu]

That doesn't happen in my dBs...


What is the rule for the conditional formatting?

Or it might be easier if you posted the dB for analysis. Maybe have 10 - 15 records - use fake data.
Do a "Compact & Repair", then Zip it.

[edmscan]

It is .. value equals to txtRadio. It does change color .. so it is not the rule itself.

I cannot post it .. as the DB is 10 GB in size. If I get no answers on here, I will see what I can do to fake it and post a file. But it is very basic with only 1 rule.
I would prefer to change the background of the whole line .. but this is fine.

Don't know if it matters but the top 'radio' control on the data portion of the screen is where the focus is .. once the button is pressed.

[Missinglinq]

Access has a file size limit of 2 GB...how do you making one that is 10 GB in size?

Linq ;0)>

[edmscan]

5 files ... ;-) Right now .. on the 4th file, and about 50 million records.

[RuralGuy]

Have you tried putting a Me.Repaint or Me.Refresh in the code of your button?

[edmscan]

Yes .. no difference.

I made a fake database to demonstrate the issue.

All you have to do in the attached database is click the button.
The records that match the radio entered (3679) I want to highlight in orange with white text.

It does not appear complicated .. but I am not that familiar with Conditional Formatting and it could be something simple.

Test.zip

[ssanfu]

I threw together this demo.... without knowing the code behind the button on your form (or seeing your dB), cannot do much more. No code used (except to set the focus to the control "txtRadio".

Be aware that "Date", "Time", "Type" and "Description" are reserved words in Access and shouldn't be used as object names. (If you are using them as field names).


Edit: I just found your test dB.....

[edmscan]

Steve .. no Oops needed. Your method works just fine and my form is working as it should. I just need to pretty it a bit.

Well .. it worked for about 15 min. It is now broken again with the exact same issue. I am interested in your comments on my test db.

I found my issue .. when I made the background transparent I can no longer see that it is highlighted. Smiles. This one is done.

[ssanfu]

OK, this is a simple fix.

The Back Style property of the control "Radio" is set to Transparent. Change it to NORMAL. Change the value of txtRadio to test the conditional formatting..

Also, on the DATA tab, you can set these properties (if you want):
ENABLED = NO and
LOCKED = YES

I see I am using 'Type' .. but it has not caused me any issues.

Yes, but it could. And when you least expect it.
Besides "Type", you also have "Group", "Name" and "User".... all reserved words...

[edmscan]

Too funny .. we found the same thing at the same time. Thanks for all your help.

With a little conditional formatting magic .. it is perfect now. Super happy on this one.

[ssanfu]

Great minds think alike!!
Good luck with your project...



Edited.....