How to use VBA code to get colors in my report ?

[valdg_]

Hi everyone, this is my first post here and english is not my first language, I will try to ask my question as clear as I can.

I've never used VBA code before (well only to draw a rectangle..). Now I'm trying to change backround color for one of my controls, in a report. I want the background to be yellow when the value inside is "Nouvelle piste d'action".
Now I don't know if it matters here but I'm working on linked Excel tables.

I did explore the BackColor code but I don't get how to call for my control the correct way.... or maybe there's other errors I don't see yet.

Actually my code is like this:

If (Me!acteur__2018_23_statut Like "Nouvelle piste d'action") Then
Me!acteur__2018_23_statut.BackColor = JAUNE


End If

And ACCESS tells me that he doesn't find the field wich i'm referring. Here acteur_2018_23_statut is the name of my field. I don't know if the name I'm using is the good one... is there a way to know for sure ?

Thanks a lot for those who will take some time trying to understand and answer my question !

[pbaldy]

The simplest solution is Conditional Formatting, on the ribbon. Your code would need to use a valid color constant, and would also need an Else for values that don't meet the test.

[valdg_]

ahhh c'était trop simple !
Merci !! La mise en forme conditionnelle fonctionne très bien !

[valdg_]

Oups sorry I answered in french ahah,

I said " ahhhh it was so easy all this time ! Conditional formating is working just fine !"

Now... i don't get how to set this question as resolved...

[valdg_]

found it ! Thank you again for your time.

[pbaldy]

Happy to help! If my daughter was around, I could answer in French.