Background row colour in Access 2003 report (1 Viewer)

[access2010]

Could we please receive your assistance in helping us place a background colour in our Access 2003 reports as follows?

If the field = Trd_Action = is Sell =
Could we please be advised how to place a Yellow background for the complete row?

If the field = Trd_Action = is Buy =
There would be no background colour.

I do not know if this is possible, but could we have the following;
If the field = Trd_Action = is Buy = it would be right justified
If the field = Trd_Action = is Sell = it would be left justified
Thank you
Crystal

 

[theDBguy]

Hi. Can't look at your file right now, but have you tried using Conditional Formatting on an unbound Textbox that you place behind all the other Textboxes in the Details section of your report?

Sent from phone...

 

[arnelgp]

see your report.

 

[access2010]

arnelgp
P.E.R.F.E.C.T and thank you​

Nicole
​

 

[arnelgp]

you're welcome