Records disappearing in report with Conditional Formatting

[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.

 

[KARL DEWEY]

You did not bother to say what the data was or what format and condition you
were applying.

 

[C]

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]

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

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.

You did not bother to say what the data was or what format and condition you
were applying.