Community archive

Ask something
Discussion Locked

access help

0 helpful
10 replies

by wuz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am new to access and am creating a access report from information in a access database and need to know if there is a command or anything I can do to stop the title of the details to pop up if there is no information. I am reading the access developer's handbook and have not come upon anything but I suspect the answer might have something to do with grouping and relationship properties. Let me know if this question made any sense or if you know of a command or procedure to help.

10 replies

by karpi

Hello,

consider the Report Event_Procedure OnNoData, you can set Cancel to true.

HTH
Karpi

by wuz

I've been toying with the macro's and codes and cant figure out how to set up this nodata event; in what way would I be able to do so?

by jboardman

Try removing the records with the blanks from the underlying query. To do this, open your query in edit mode. In the Criteria area under the field(s) you want to filter out, put an argument in that looks something like your_field]<>""
or perhaps [your_field] Is Not Null
Or both, one under the other and see what you get. If the records don't show up in the report, the Title won't show up.

This discussion is closed to new replies.