record-based report formatting

[cbnewman]

What is the best way to accomplish the following:

I would like to generate a report that changes the text size and
italicization based on a boolean variable (present in the row of the
data source returned by a stored query).

In other words, the report runs and if the boolean decrease_emphasis
is true, then that row in the report is printed in a smaller,
italicized font.

It is OK to have these report rows not interleaved with the rest of
the data, so grouping by true/false value of this variable seems like
an option, but I'm having trouble implementing it.

Thanks.

[OldPro]

On Oct 22, 11:00 am, [e-mail] wrote:

What is the best way to accomplish the following:

I would like to generate a report that changes the text size and
italicization based on a boolean variable (present in the row of the
data source returned by a stored query).

In other words, the report runs and if the boolean decrease_emphasis
is true, then that row in the report is printed in a smaller,
italicized font.

It is OK to have these report rows not interleaved with the rest of
the data, so grouping by true/false value of this variable seems like
an option, but I'm having trouble implementing it.

Thanks.

The data is compiled prior to printing... you would need some way to
interupt the printing after the record is read and before the record
is printed to change the font... something like the BeforeUpdate
event... I'm not aware of anything like that. I have heard of
conditional formatting that is available in some or the newer versions
of Access, but I don't know if it extends to reports.