Background row colour in Access 2003 report (1 Viewer)

access2010

Registered User.
Local time
Yesterday, 19:22
Joined
Dec 26, 2009
Messages
1,019
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
 

Attachments

  • Conditional_Formating_Report_Buy_Sell=20=309.mdb
    320 KB · Views: 295

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:22
Joined
Oct 29, 2018
Messages
21,358
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

..forever waiting... waiting for jellybean!
Local time
Today, 10:22
Joined
May 7, 2009
Messages
19,169
see your report.
 

Attachments

  • Conditional_Formating_Report_Buy_Sell=20=309 (1).zip
    30.2 KB · Views: 144

access2010

Registered User.
Local time
Yesterday, 19:22
Joined
Dec 26, 2009
Messages
1,019

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

Nicole

 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:22
Joined
May 7, 2009
Messages
19,169
you're welcome :)
 

Users who are viewing this thread

Top Bottom