Bypassing blank fields

[RichO]

I am looking for some help on formatting a report. Here is what I am doing...

I am Querying a table for a work schedule. I will be printing 4 columns: a date, a location, a city, and hours worked, in a tabular report.

The source table also contains a special provisions field. About 1 out of every 10 jobs has a special provision, otherwise the field is blank. This field is too wide to print in its own column (up to 80 characters) so it must be printed below the date/location/city/hours line. No problem doing that but there is alot of wasted space on the report page because there is a blank space below every job that doesn't have a provision.

My question is, how can I set up the report so it does NOT print the blank space in between each line when the special provision field is null?

Thanks.

 

[RichO]

There are no labels in the detail section, actually there are no labels for any of the fields at all.

Where would this code be inserted? Would it go into an on click event procedure from the command button that runs this report?

Are SomeLabel and SomeField VBA keywords or does SomeField represent where I would insert [Special_Provisions]? If so, what does SomeLabel represent being that there are no labels used on this report?

Thanks for your help.

I realize that I am going to have to get a better access book, such as the developer's handbook. The one I have just isn't giving me all the info I need.

 

[MikTylor]

Just a quick question here.

As per the previous questions, what of there ARE labels that need to be hidden? Where does the code go?

Thank
Mik