Not printing blank fields

[kcolbert01]

I've done this before with address lables but can't remember how. I have a report that is based on a table that has fields that may or maynot have data. When printing, I would like the report to only include the fields when there is data.

Is there a way to do this? Please keep in mind that I am a beginner at coding (if it requires it)

Thanks

 

[twitchie]

I believe you just set the "Can Shrink" property to yes for that report.

 

[yippie_ky_yay]

James is right - but you select the Can Shrink property for each of the fields that you would like to disapear.

(Don't set it to Yes for the Details section or it will mess up your label sizes and therefore its position)

-Sean

 

[kcolbert01]

Thanks for the replies but that's not working. I even deleted the labels associated with the field and set the properties to can shrink and made sure the detail was set to NO - but I'm still getting these huge blank spaces when trying to print the report.

Any other ideas?

 

[Matt Rayne]

Are there any objects in your report? I had this same problem but it was because the information shared space with a text box that had information in it.

 

[jboland]

What you need to do is base your report on a query. Make the query from the table, and include all the fields you want to be in the report. Open the query in design mode, find the field or fields that contain the blank values. in the criteria section of that field type:

Not Like "Blank"

Then build your report off of that query.

Hope that helps

 

[Pat Hartman]

Set the can shrink/can grow properties to yes for ALL controls in the detail section. Also, set the can shrink/can grow properties for the detail section itself to yes. Make sure that no controls overlap. Hide any label fields whose cooresponding textbox will be blank.

Access will compress out rows that are totally empty.

 

[kcolbert01]

Nothing is working

I have set all 20 fields to YES for Can Grow/Can Shrink and none of the fields are overlapping. I have also made it so that the labels are hidden if the field is null and I still end up with a huge space. Are there any other ideas...

 

[Pat Hartman]

You need to make the detail section as small as possible. I posted a picture so you can see what I'm talking about. In this report the height of the Detail section is .25" and the height of the controls in the section are 0.2083". This means that a line = to (.25 - .2083) is going to print even if the controls are hidden.

I doubt that you'll be able to eliminate all waste space, but do your best. The more lines of controls you have in the section the more waste space you'll have.