access report

[jurban]

I am posting a report to the web, in a pdf format. the issue is I have data that is hidden under conditional formating in which if it meet the criteria the font is white and background white. This is great since it shows up blank on pdf. However if a slick person takes the pdf highlights the page and transfers it to a word document, he can highlight that area change the font to black and see the data. Is there a way to hide the data prior to creating a pdf.

[June7]

I did not know that!

You are using conditional formatting to just change the text and background colors? Could you instead use an expression in textbox that will return Null or empty string if a condition is met?

[jurban]

Can someone give me an example of how I could write an expression that will return a null.

I did not know that!

You are using conditional formatting to just change the text and background colors? Could you instead use an expression in textbox that will return Null or empty string if a condition is met?

[June7]

From my db:

=IIf([TestNum]="201",Null,[VTM])

[jurban]

I really appreciate your help. Here is what I'm trying to accomplish.
Where do I apply the condition when I try to apply to report it doesn't like the =IIf also when I run without that I get [VTM] pop-up
My field name is building and what I'm try to set to null is "non-reportable"

From my db:

=IIf([TestNum]="201",Null,[VTM])

[June7]

What I gave you is just an example. It is an expression in a textbox ControlSource property. TestNum and VTM are field names from my table. I have no idea what condition you need to test for nor what your field names are.

[jurban]

Thank you so much, once you explained it was a text box control, I was able to solve the problem. Really appreciate the help.

What I gave you is just an example. It is an expression in a textbox ControlSource property. TestNum and VTM are field names from my table. I have no idea what condition you need to test for nor what your field names are.