*hiding* something that has null value, only when it is null

[kellydor]

I have a report(relatively new to all this, please bear with me) that I've created in Access 2000. In the report, it contains the fields of a table that I created, from a form that I am using as a "template" to give to co-workers, to fill out their daily *notes* for the day. Any way, the report looks fab and there is nothing *wrong* per se, but here is my question.

There are two cells which contain information, based on the hour's topic. Say the first one says "hour" and the hour is hour "J". Say the next textbox contains the "Title" of the hour. The Title being "Northgate Products". Now, within the hour, are "sequence" numbers and "item numbers", along with "issues" for that particular item. The two cells that relate to the hour, are in every single bit of "data" contains the hour's information. However, there only exists the "hour" and "title" at the top of an hour. The other information is displayed, as per item. Let me see if I can show this more clearly.

First part of information, per hour:
Hour= J Title= Northgate Products Date Entry= 1/1/05

Second part of information:
Seq #= 100 Item #= 123-123 Description= Orange Box

What I want to do, is when I get to "101" on the Sequence, to NOT display the Hour "J", Title "Northgate..." & "1/1/05"

I hope this makes sense. I'm still new to working with Access at the programming end(never done any REAL programming, previously) and am not yet familiar with the proper "Code" Language.


-K. Dorsett

 

[Remou]

It seems to me, from your explanation, that you need to group on one of these items:
Hour= J Title= Northgate Products Date Entry= 1/1/05

 

[SeeThru]

You can use the OnFormat of the report section the fields are in, and something like:

If isnull(field) then
field.cisible=false
else
field.visible=true
end if


Yuo can also programtically change the size, but have a look at the canshrink option first - it's easier.

 

[dhookom]

Is it possible that you just want to "Hide Duplicates"?

BTW: There are not cells in Access (that's Excel). In Access there are fields which are contained in tables and queries. Your reports and forms will have controls that might display values from your fields.

When asking questions it is often advantageous to provide some table and field names as well as sample records. If you are asking a query or report question, it helps to know what you would like your output to look like based on your sample records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]