Suppressing particular detail lines for blank data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 27 Mar 2005 18:34 GMT

I have a report based on a query where a number of the data elements are
Nulls. I would like to suppress the detail when certain conditions are
met, ie, certain fields are Null. When I try to set
Detail.Visible = False, I get NOTHING printed for any record line.

I suppose I could redo the query to eliminate this, but I use the same
query for other reports, and I'd like to minimize the complexity if
possible.

Thanks

Steve

Reply to this Message

Rick Brandt - 27 Mar 2005 18:42 GMT

> I have a report based on a query where a number of the data elements
> are Nulls. I would like to suppress the detail when certain
[quoted text clipped - 8 lines]
>
> Steve

In the format event of the relevent section...

Cancel = IsNull(Me.SomeField)

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Steve - 27 Mar 2005 23:55 GMT

BINGO! That works great! Thanks.

So why is this nowhere to be found in the docs??? <g>

Steve

>>I have a report based on a query where a number of the data elements
>>are Nulls. I would like to suppress the detail when certain
[quoted text clipped - 12 lines]
>
> Cancel = IsNull(Me.SomeField)

Reply to this Message

Marshall Barton - 27 Mar 2005 20:05 GMT

>I have a report based on a query where a number of the data elements are
>Nulls. I would like to suppress the detail when certain conditions are
[quoted text clipped - 4 lines]
>query for other reports, and I'd like to minimize the complexity if
>possible.

If you use a form button to initiate the report, then you
can filter the report's data by using the OpenReport
method's WhereCondition argument:

stDoc = "reportname"
stWhere = "fldA Is Not Null AND fldB Is Not Null"
DoCmd.OpenReport stDoc, , , stWhere

Signature

Marsh
MVP [MS Access]

Reply to this Message