如果已选中，则在报表上显示表单中的字段 [英] Showing a field in a form on a report if it's checked

问题描述

嘿所有，


我有一份报告，我希望根据表格中是否检查

字段来显示单词。例如。该表格有一个复选框

称为费用。如果选中，我希望单词Paid出现在

报告中。如果没有检查，那么我希望它不显示。


感谢您的帮助！

解决方案

2007年11月20日星期二13:13:40 -0800（太平洋标准时间），radink写道：

嘿所有，

我有一份报告，我希望根据表格中是否检查

字段来显示单词。例如。该表格有一个复选框

称为费用。如果选中，我希望单词Paid出现在

报告中。如果没有检查，那么我希望它不显示。


感谢您的帮助！

字段[费用]是否包含在报告的记录源中？

如果是，则添加未绑定的文本控件到报告。

将它的控制源设置为：

= IIf（[费用] =真，付费，）

如果表格上的复选框未包含在报告的记录

来源中，则将未绑定的控件添加到报告中。

将它的控制源设置为：

= IIf（表格！FormName！费用=真，付费，"）


报表运行时表格必须打开。


-

Fred

请仅回复此新闻组。

我不回复个人电子邮件

11月20日下午4:35，fredg< fgutk ... @ example.invalidwrote：

2007年11月20日星期二13:13:40 -0800（太平洋标准时间），radink写道：

嘿所有，

我有一个报告，我希望根据表格中是否检查

字段来显示单词。例如。该表格有一个复选框

称为费用。如果选中，我希望单词Paid出现在

报告中。如果没有检查，那么我希望它不显示。

感谢您的帮助！

报告的记录源中是否包含[费用]字段？

如果是，则添加未绑定的文本控件到报告。

将它的控制源设置为：

= IIf（[费用] =真，付费，）

如果表格上的复选框未包含在报告的记录

来源中，则将未绑定的控件添加到报告中。

将它的控制源设置为：

= IIf（表格！FormName！费用=真，付费，"）


报表运行时表格必须打开。


-

Fred

请仅回复此新闻组。

我不回复个人电子邮件

我做了选项2，因为它没有链接。它有效，但不是。如果将'/ b
设置为true，它就不会显示在任何一个上，如果我将其设置为false它将会显示在所有这些上面。

显示它们。我运行时确实打开了表格。


谢谢！

11月20日下午2:56，radink < radi ... @ gmail.comwrote：

11月20日下午4:35，fredg< fgutk ... @ example.invalidwrote：

2007年11月20日星期二13:13:40 -0800（太平洋标准时间），radink写道：

嘿所有，

我有一份报告，我会喜欢根据表单中是否检查

字段显示单词。例如。该表格有一个复选框

称为费用。如果选中，我希望单词Paid出现在

报告中。如果没有检查，那么我希望它不显示。

感谢您的帮助！

报告的记录来源中是否包含[费用]字段？

如果是，然后在报告中添加一个未绑定的文本控件。

将它的控制源设置为：

= IIf（[费用] =真，付费， ""）

如果表单上的复选框未包含在报告的记录中

来源，然后在报告中添加一个未绑定的控件。

将它的控制源设置为：

= IIf（表格！FormName！费用=真，付费 ;，""）

运行报表时必须打开表单。

-

Fred

请回复此新闻组。

我不回复个人电子邮件

我做了选项2，因为它没有链接。它有效，但不是。如果将'/ b
设置为true，它就不会显示在任何一个上，如果我将其设置为false它将会显示在所有这些上面。

显示它们。我运行时确实打开了表格。


谢谢！ - 隐藏引用的文字 -


- 显示引用的文字 -

由于[费用]已经是真或假，省略你的IIF中的= True部分：

= IIf（[费用]，付费 ;，""）


我在使用评估为''如果是真的=

true''时有时会看到愚蠢。 />

HTH，

Jana

Hey All,

I have a report that I would like to show a word on based on if a
field is checked in a form. For example. The form has a check box
called Fee. If that is checked, I want the word Paid to show up in the
report. If it''s not checked, then I want it to not show.

Thanks for any help!

解决方案

On Tue, 20 Nov 2007 13:13:40 -0800 (PST), radink wrote:

Hey All,

I have a report that I would like to show a word on based on if a
field is checked in a form. For example. The form has a check box
called Fee. If that is checked, I want the word Paid to show up in the
report. If it''s not checked, then I want it to not show.

Thanks for any help!

Is the field [Fee] included in the report''s record source?
If so, then add an unbound text control to the report.
Set it''s control source to:
=IIf([Fee] = True,"Paid","")

If the check box on the form is NOT included in the report''s record
source, then add an unbound control to the report.
Set it''s control source to:
=IIf(forms!FormName!Fee = True, "Paid","")

The form must be open when the report is run.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Nov 20, 4:35 pm, fredg <[e-mail]:

On Tue, 20 Nov 2007 13:13:40 -0800 (PST), radink wrote:

Hey All,

I have a report that I would like to show a word on based on if a
field is checked in a form. For example. The form has a check box
called Fee. If that is checked, I want the word Paid to show up in the
report. If it''s not checked, then I want it to not show.

Thanks for any help!

Is the field [Fee] included in the report''s record source?
If so, then add an unbound text control to the report.
Set it''s control source to:
=IIf([Fee] = True,"Paid","")

If the check box on the form is NOT included in the report''s record
source, then add an unbound control to the report.
Set it''s control source to:
=IIf(forms!FormName!Fee = True, "Paid","")

The form must be open when the report is run.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

I did option 2, since it''s not linked. It works but doesn''t. If it''s
set to true it doesn''t show on any of them, if I set it to false it
shows it on all of them. I do have the form open when Im running it.

Thanks!

On Nov 20, 2:56 pm, radink <[e-mail]:

On Nov 20, 4:35 pm, fredg <[e-mail]:

On Tue, 20 Nov 2007 13:13:40 -0800 (PST), radink wrote:

Hey All,

I have a report that I would like to show a word on based on if a
field is checked in a form. For example. The form has a check box
called Fee. If that is checked, I want the word Paid to show up in the
report. If it''s not checked, then I want it to not show.

Thanks for any help!

Is the field [Fee] included in the report''s record source?
If so, then add an unbound text control to the report.
Set it''s control source to:
=IIf([Fee] = True,"Paid","")

If the check box on the form is NOT included in the report''s record
source, then add an unbound control to the report.
Set it''s control source to:
=IIf(forms!FormName!Fee = True, "Paid","")

The form must be open when the report is run.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

I did option 2, since it''s not linked. It works but doesn''t. If it''s
set to true it doesn''t show on any of them, if I set it to false it
shows it on all of them. I do have the form open when Im running it.

Thanks!- Hide quoted text -

- Show quoted text -

Since [Fee] is already True or False, omit the =True part in your IIF:
=IIf([Fee],"Paid","")

I''ve sometimes seen goofiness when using what evaluates to ''IF true =
true''.

HTH,
Jana

这篇关于如果已选中，则在报表上显示表单中的字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！