Check box question

[rob p]

On a form, if I have a checkbox checked I then want to print the word VOID
on my report showing the same record. Also, this is a subreport so I want to
count the number of VOID's (checked boxes) and bring total over to main
report.

This comes from a table with all fields including the checkbox. I then use a
query for the form and report.

Thanks.
rob

 

[Wayne Morgan]

Place a textbox on the main report and set its Control Source to

=DCount("[FieldName]", "Table Name", "[FieldName]=True")

In the subreport, place a label with the word VOID as its caption where you
want the word to print in the section of the report. In the OnFormat event
of the section set the Visible property of the label to the value of the
checkbox field.

 

[fredg]

On a form, if I have a checkbox checked I then want to print the word VOID
on my report showing the same record. Also, this is a subreport so I want to
count the number of VOID's (checked boxes) and bring total over to main
report.

This comes from a table with all fields including the checkbox. I then use a
query for the form and report.

Thanks.
rob

Rob,
To show the show the word "Void" on the report when the CheckBox value
is True (-1), add an Unbound control to the report. Set it's Control
Source to that of the CheckBox field.
Set it's Format property to:
;"Void";

What do you wish to show if the value of the CheckBox is False?
;"Void";False Value here;
See Access help files regarding Format property + Numbers and Currency