I have a report with a checkbox: [SentPPTSlide] and name is chkSentPPTSlide
I know that a check box can either be checked or not checked.
I have crafted this IIF below in the control source of chkSentPPTSlide but I dont think I can display "NA" (on the report [SentPPTSlide] is greyed out for any value that is "No" for [cboPPTNeeded]).
Any ideas on how I could show an "NA" when the condition is true? I imagine a solution might be to use an overlay text box with On Detail_Format event but I have done this and the issue with this solution is that the overlay apparently only shows on print preview. For this reason, I want to use something else besides an overlay.