IIF not working consistently

  • Thread starter Thread starter WestWingFan
  • Start date Start date
W

WestWingFan

I have a report with a subreport. On the main report is a text box with the
following IIF statement for its control source:

=IIf([sbrptCAAppStdsbyGroup].[Report].[HasData],"______",Null)

It was working perfectly until I tried to run the report on the new set of
data. Now there are times that the IIF doesn't fire correctly (in some cases
there is a _____ when there shouldn't be and there is no _____ where there
should). But some times the statement works as intended. I don't even know
where to begin troubleshooting this one.

Thanks in advance for your help!
 
Duane!

I'm so glad you answered. No, the text box is in a separate section of the
main report. The subreport is in the detail section.

Duane Hookom said:
Is the text box in the same section of the main report as the subreport?
--
Duane Hookom
Microsoft Access MVP


WestWingFan said:
I have a report with a subreport. On the main report is a text box with the
following IIF statement for its control source:

=IIf([sbrptCAAppStdsbyGroup].[Report].[HasData],"______",Null)

It was working perfectly until I tried to run the report on the new set of
data. Now there are times that the IIF doesn't fire correctly (in some cases
there is a _____ when there shouldn't be and there is no _____ where there
should). But some times the statement works as intended. I don't even know
where to begin troubleshooting this one.

Thanks in advance for your help!
Click to expand...
Click to expand...
 
So, I tried moving the textbox into the detail area of the report. It seems
to have fixed it for the moment. I wonder if the different section was
causing the programing to get out of synch...

Thanks for the suggestion!

WestWingFan said:
Duane!

I'm so glad you answered. No, the text box is in a separate section of the
main report. The subreport is in the detail section.

Duane Hookom said:
Is the text box in the same section of the main report as the subreport?
--
Duane Hookom
Microsoft Access MVP


WestWingFan said:
I have a report with a subreport. On the main report is a text box with the
following IIF statement for its control source:

=IIf([sbrptCAAppStdsbyGroup].[Report].[HasData],"______",Null)

It was working perfectly until I tried to run the report on the new set of
data. Now there are times that the IIF doesn't fire correctly (in some cases
there is a _____ when there shouldn't be and there is no _____ where there
should). But some times the statement works as intended. I don't even know
where to begin troubleshooting this one.

Thanks in advance for your help!
Click to expand...
Click to expand...
Click to expand...
 
I expect that was the issue. You could keep it in both sections to check it
out.

--
Duane Hookom
Microsoft Access MVP


WestWingFan said:
So, I tried moving the textbox into the detail area of the report. It seems
to have fixed it for the moment. I wonder if the different section was
causing the programing to get out of synch...

Thanks for the suggestion!

WestWingFan said:
Duane!

I'm so glad you answered. No, the text box is in a separate section of the
main report. The subreport is in the detail section.

Duane Hookom said:
Is the text box in the same section of the main report as the subreport?
--
Duane Hookom
Microsoft Access MVP


:

I have a report with a subreport. On the main report is a text box with the
following IIF statement for its control source:

=IIf([sbrptCAAppStdsbyGroup].[Report].[HasData],"______",Null)

It was working perfectly until I tried to run the report on the new set of
data. Now there are times that the IIF doesn't fire correctly (in some cases
there is a _____ when there shouldn't be and there is no _____ where there
should). But some times the statement works as intended. I don't even know
where to begin troubleshooting this one.

Thanks in advance for your help!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top