Records disappearing in report with Conditional Formatting

  • Thread starter Thread starter C
  • Start date Start date
C

C

I have a report that is based on a table. All of the records appear when I
preview the report. However, whenever I preview the report after applying
any sort of conditional formatting, only the first record appears. The rest
has disappeared.

I have made a form with the same data and the same conditional formats, and
it works fine. Other reports with the same conditional formats also work
fine. I have tried changing the conditions for formatting, but the data
disappears no matter what the condition is. I have tried setting the
conditional formats both from the format menu and by using VBA, and it
happens either way.

Any ideas why the data is disappearing? Thanks.
 
You did not bother to say what the data was or what format and condition you
were applying.
 
The records contain a mixture of text fields and data fields. All of the
fields have the same condition, which is an expression:

[Field10]="ALL", then backcolor is yellow.

I have other reports based on other tables with the same conditions, and it
worked fine for all the rest of them.

One other thing I just noticed. Initially Field10 was just in the table and
not in the report itself. So I tried putting it in the report and making it
invisible. When that happened, the records disappeared whether conditional
formatting was used or not. I tried making it visible and it still didn't
work.

Thanks.
 
I probably will not be able to help you but where did you apply the condition?
--
KARL DEWEY
Build a little - Test a little


C said:
The records contain a mixture of text fields and data fields. All of the
fields have the same condition, which is an expression:

[Field10]="ALL", then backcolor is yellow.

I have other reports based on other tables with the same conditions, and it
worked fine for all the rest of them.

One other thing I just noticed. Initially Field10 was just in the table and
not in the report itself. So I tried putting it in the report and making it
invisible. When that happened, the records disappeared whether conditional
formatting was used or not. I tried making it visible and it still didn't
work.

Thanks.

KARL DEWEY said:
You did not bother to say what the data was or what format and condition you
were applying.
Click to expand...
Click to expand...
 
Back
Top