隐藏报表中没有数据的字段 [英] Hide fields in a report which do not have data

问题描述

是否有办法隐藏报告中没有任何数据的字段。我有很少的字段有图像，我想隐藏它们，只要没有。我正在使用Access 07.

Is there a way to hide fields in a report that do not have any data. I have few fields that have images and I would like to hide them as well whenever there is none. I am using Access 07.

推荐答案

这可以通过将相应字段的可收缩属性更改为是来完成吗？

Could this be done by changing the ''Can Shrink'' property of the appropriate field to ''Yes''?

Hi Hedges98 - 我试过了，但是我没有看到任何变化。


谢谢。

Hi Hedges98 - I tried that, however I did not see anything changing.

Thank you.

在格式化事件中，如果该字段为空，则将字段'的visible属性设置为false

假设这是在报告详细信息中，此代码将在详细信息部分的格式事件中


if isnull（me！fieldname）然后

me！fieldname.visible = false

else

me！fieldname.visible = true

endif

In the format event, if the field is empty set the field''s visible property to false
Assuming this is in the report detail, this code would be in the Detail section''s format event

if isnull(me!fieldname) then
me!fieldname.visible = false
else
me!fieldname.visible = true
endif

这篇关于隐藏报表中没有数据的字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！