How do I suppress (no blank lines) fields in Access under certain.

[Guest]

I want a field in an Access 2000 report to be suppressed when a specific
condition is true. Is there a way to get the field to have zero height when
an Iif statement is true and the normal height when it is not? Or any way
that generates the report without that field (or a blank line) under the
specific condition?

 

[Duane Hookom]

You can suppress the printing of a record using code in the On Format event
of the section like:
Cancel = [Your True/False Conidtion]
The condition must reference bound controls.

 

[Guest]

Thanks for responding. I didn't explain the problem completely. I don't want
to suppress the record, only the field when it's blank - the way a label
address closes the empty space in an address when one address line is blank
(e.g. if [Address2] is blank, you don't see a blank line on the address
label. Can I do this in an Access report?

You can suppress the printing of a record using code in the On Format event
of the section like:
Cancel = [Your True/False Conidtion]
The condition must reference bound controls.

--
Duane Hookom
MS Access MVP
--

I want a field in an Access 2000 report to be suppressed when a specific
condition is true. Is there a way to get the field to have zero height
when
an Iif statement is true and the normal height when it is not? Or any way
that generates the report without that field (or a blank line) under the
specific condition?

 

[Duane Hookom]

If the control value is null, you can set its Can Shrink property to Yes and
it will shrink. This doesn't shrink stuff around it.

--
Duane Hookom
MS Access MVP
--

Thanks for responding. I didn't explain the problem completely. I don't
want
to suppress the record, only the field when it's blank - the way a label
address closes the empty space in an address when one address line is
blank
(e.g. if [Address2] is blank, you don't see a blank line on the address
label. Can I do this in an Access report?

You can suppress the printing of a record using code in the On Format
event
of the section like:
Cancel = [Your True/False Conidtion]
The condition must reference bound controls.

--
Duane Hookom
MS Access MVP
--

I want a field in an Access 2000 report to be suppressed when a specific
condition is true. Is there a way to get the field to have zero height
when
an Iif statement is true and the normal height when it is not? Or any
way
that generates the report without that field (or a blank line) under
the
specific condition?

 

[Guest]

Thank you!!! It worked.

If the control value is null, you can set its Can Shrink property to Yes and
it will shrink. This doesn't shrink stuff around it.

--
Duane Hookom
MS Access MVP
--

Thanks for responding. I didn't explain the problem completely. I don't
want
to suppress the record, only the field when it's blank - the way a label
address closes the empty space in an address when one address line is
blank
(e.g. if [Address2] is blank, you don't see a blank line on the address
label. Can I do this in an Access report?

You can suppress the printing of a record using code in the On Format
event
of the section like:
Cancel = [Your True/False Conidtion]
The condition must reference bound controls.

--
Duane Hookom
MS Access MVP
--

I want a field in an Access 2000 report to be suppressed when a specific
condition is true. Is there a way to get the field to have zero height
when
an Iif statement is true and the normal height when it is not? Or any
way
that generates the report without that field (or a blank line) under
the
specific condition?