Do not leave space on blank records

[Hemish]

Hi,

In Ms Access 2000, is there any way not to show a blank space in detail part?

For Example I have a group heading called Stock and if there is no history for stock under detail I do not want a blank gap there instead move to the next record. The gap is there is because if there was data for the record it would come out, but if there is no record I do not want to show a blank space.

Is there any way to get rid text boxes which are blank so the report is more compact

Thank you in advance

 

[georgedwilkinson]

Filter your result set to ignore records without data in that field. You can probably do that by modifying the underlying query and putting is not null and <> "" for that field in the criteria.

 

[boblarson]

Depends on how your report is set up, but you can set the controls' CAN SHRINK property to YES, but if you do that you must have the section's CAN SHRINK property also set to YES.