How do I Not Print field labels in a report?

[DAmoss]

Hi,

I have 30 outputs which each consist of the following detail, when the tickbox is false I want all of details to be ignored and not printed, I have set the fields to shrink if there is no data.

Tickbox & label
Text field
Date field

But I cannot do the same for the tickbox label. I can set its visibility to false depending on the tickbox value, but it still leaves a nice blank space, I really need to close this unwanted gap up.

Can anyone help please?

Cheers

 

[Remou]

Why not set the whole detail section's visibility property?

 

[dhookom]

You can change the label to a text box with a control source like:
=IIf([SomeField]=True,"Caption Value",Null)
It will then shrink.

Duane
Hook'D on Access
MS Access MVP

 

[genomon]

Or set cancel = true in the detail print or format event?

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[DAmoss]

dhookom:

The example you gave me worked to point, it turned off all the labels, but it didn't close up the gap totally, It left a 2cm gap still there. I have set everything to shrink / expand but I still get this blank space between my fields!

My records contain the following fields in a horizontal line, they are currently shown in a Sub-Report attached to their linked main record:

Tickbox [Achieved 1] with a label
Textbox [Output 1] no label
Date [DateAchieved 1] no label

There are 20 output fields numbered like the above. when the tickbox is false I need the relevant record to close up and not be printed.

Any ideas as to what I might have missed?

 

[dhookom]

Controls will never shrink horizontally to close a gap without running code to set the Left property of the controls.

I'm not sure what your current fields are, their data types, possible values, and how you want them to display or hide. I think the issue might be resolved by normalizing your table and using a multi-column subreport.

Duane
Hook'D on Access
MS Access MVP