IIF not working consistently

[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 Hookom]

Is the text box in the same section of the main report as the subreport?

 

[WestWingFan]

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.

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!

 

[WestWingFan]

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!

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.

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!

 

[Duane Hookom]

I expect that was the issue. You could keep it in both sections to check it
out.

--
Duane Hookom
Microsoft Access MVP

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!

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.

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!