希望报告仅在选中复选框时显示“是”，如果不选中则显示为空白。 [英] Want Report to only show yes if checkbox is checked, and blank if it's not.

问题描述

希望这有一个简单的解决方案，无论是VBA还是属性框。

我在Access中有一个名为JeppList的报告，其中[Rush]字段从中提取数据我的表格名为OrderForm，来自一个复选框（也称为[Rush]）。


该报告工作正常但是是如果选中该复选框，则否如果留空。


但是，此列表会发送给非现场供应商。而不是一长串的是和否，他们必须梳理并找到是。我只是希望显示yes'，而'no'显示空白/ null值。这可能吗？我感谢任何帮助！


谢谢！

解决方案

您是在谈论一个简单的过滤器，以便只记录设置包含 [Rush] =是？

感谢您回复NeoPa。实际上不，我不希望这个过滤掉任何记录。


我想要显示报告中的所有记录，但字段[Rush]会显示否。如果复选框留空，我宁愿保持空白。我希望这样，以便在扫描报告时，您可以非常快速地看到哪些记录具有是。值，因为否值留空。我希望这有帮助。提前谢谢你。

啊，现在更有意义了。


在[Rush]控件中，而不是拥有一个控制源[Rush]，而不是 = IIf（[Rush]，''Yes''，Null）


或者，如果报告绑定到查询，你可以将[Rush]字段设为 IIf（Table.Rush，''是''，Null）AS [Rush]

Hopefully this has a simple solution either by VBA or in the properties box.

I have a report in Access called JeppList in which the field [Rush] is pulling the data from my form entitled OrderForm from a checkbox (also called [Rush]).

The report is working fine listing "yes" if the checkbox is checked, and "no" if it is left blank.

However, this list goes to an offsite vendor. Instead of a long list of yes''s and no''s where they have to comb through and find the yes''s. I simply wish for the yes''s to show up, and the no''s to show a blank/null value. Is this possible? I appreciate any assistance!

Thanks!

解决方案

Are you talking about a simple filter so that only records which are set to [Rush] = Yes are included?

Thanks for responding NeoPa. Actually no, I don''t want this to filter out any records.

I want all of the records in the report to show, but where the field [Rush] would show a "No" if the checkbox is left blank, I would rather it stay empty. I would like this so that when scanning the report, you can very quickly see which records have a "Yes" value, because the "No" values are left blank. I hope this helps. Thank you in advance.

Ah, that makes more sense now.

In the [Rush] control, instead of having a Control Source of [Rush], have instead =IIf([Rush],''Yes'',Null)

Alternatively, if the report is bound to a query, you could have the [Rush] field as IIf(Table.Rush,''Yes'',Null) AS [Rush]

这篇关于希望报告仅在选中复选框时显示“是”，如果不选中则显示为空白。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！