This has really stumped me....
I have two identical reports, "School Search by Name" and "School Search by Address". The only difference between them is the parameters used to load the reports. Three fields in each report are conditionally formatted to appear the same colour as the background (ie become invisible) based on the value of another field. Here's the expression I'm using for two fields [School Website] and [School Phone Number]:
Expression is [Status_SchoolStatus]="Closed"
And for the other field [Closing Date]:
Expression is [Status_SchoolStatus]="Currently Active"
I've gone through the data and format properties of the [Status_SchoolStatus] field as well as the conditionally formatted fields, but I can't find any discrepancies. And yet, my conditional formatting works fine in "School Search by Name" but not at all in "School Search by Address".
What could possibly be going wrong here?
I should mention that I've only been working with Access for about six months and I am not good at coding. I may have a lot of questions. Please accept my preemptive apologies.
I have two identical reports, "School Search by Name" and "School Search by Address". The only difference between them is the parameters used to load the reports. Three fields in each report are conditionally formatted to appear the same colour as the background (ie become invisible) based on the value of another field. Here's the expression I'm using for two fields [School Website] and [School Phone Number]:
Expression is [Status_SchoolStatus]="Closed"
And for the other field [Closing Date]:
Expression is [Status_SchoolStatus]="Currently Active"
I've gone through the data and format properties of the [Status_SchoolStatus] field as well as the conditionally formatted fields, but I can't find any discrepancies. And yet, my conditional formatting works fine in "School Search by Name" but not at all in "School Search by Address".
What could possibly be going wrong here?
I should mention that I've only been working with Access for about six months and I am not good at coding. I may have a lot of questions. Please accept my preemptive apologies.