Report Detail Section text box Highlight issue (1 Viewer)

Suresh_Murugan · Oct 10, 2017

Dears,

Please help me on How to highlight report detail section text boxes.
I am prepared the overall summary report for a project.
If outstanding =0 then I want to highlight entire ROW.
I try to this using conditional formatting but not working.
So please help me.....

arnelgp · Oct 10, 2017

why not working the Conditional Format?

put your report in design view.
select all your field in the Detail
section.
on Ribbon->Format->Conditional Formatting.
On New Rule, First Combobox->Expression Is: Nz([Outstanding], 0)=0
choose the Background color you want.
Press OK, Press Apply.

Suresh_Murugan · Oct 10, 2017

arnelgp said:
why not working the Conditional Format?

put your report in design view.
select all your field in the Detail
section.
on Ribbon->Format->Conditional Formatting.
On New Rule, First Combobox->Expression Is: Nz([Outstanding], 0)=0
choose the Background color you want.
Press OK, Press Apply.

Thanks for your replying.
I was using same your way but doesn't work properly (Print Preview not highlighted)

arnelgp · Oct 10, 2017

I am using Nz() function are you?

Suresh_Murugan · Oct 10, 2017

arnelgp said:
I am using Nz() function are you?

Yes, Same function I used.

But not working....

arnelgp · Oct 10, 2017

Show me your query and the textbox name of outstanding field and its row source

Suresh_Murugan · Oct 10, 2017

arnelgp said:
Show me your query and the textbox name of outstanding field and its row source

Refer attached Picture query and report
Text box name is Text3-Disc, Text5-O/s

arnelgp · Oct 10, 2017

Have you already tried

Nz([Text-5-O/s], 0) = 0

on the Expression Is box
of Conditional Formatting?

if so, can you upload a Test
version of your db.

i used the above Textbox name
on my test db and it is formatting.

Suresh_Murugan · Oct 10, 2017

arnelgp said:
Have you already tried

Nz([Text-5-O/s], 0) = 0

on the Expression Is box
of Conditional Formatting?

if so, can you upload a Test
version of your db.

i used the above Textbox name
on my test db and it is formatting.

No it is also not working

arnelgp · Oct 10, 2017

i can't think of anything but
one, if it is a text:

Val("0" & [Text-5-O/s]) = 0

arnelgp · Oct 10, 2017

vba won't help either
because our condition
would be the textbox = 0.

is it possible for you to .zip
your db and post it.

Suresh_Murugan · Oct 10, 2017

arnelgp said:
vba won't help either
because our condition
would be the textbox = 0.

is it possible for you to .zip
your db and post it.

Refer data base

arnelgp · Oct 10, 2017

the Formatting is not coming out
because all your Textbox Backstyle
is Transparent. I set it to Normal.

Suresh_Murugan · Oct 11, 2017

Thank you very much. It's working properly

arnelgp · Oct 11, 2017

You're welcome sir

Report Detail Section text box Highlight issue (1 Viewer)

Suresh_Murugan

Registered User.

Attachments

arnelgp

..forever waiting... waiting for jellybean!

Suresh_Murugan

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Suresh_Murugan

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Suresh_Murugan

Registered User.

Attachments

arnelgp

..forever waiting... waiting for jellybean!

Suresh_Murugan

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

arnelgp

..forever waiting... waiting for jellybean!

Suresh_Murugan

Registered User.

Attachments

arnelgp

..forever waiting... waiting for jellybean!

Attachments

Suresh_Murugan

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread