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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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?

Duane Hookom said:
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
--

bbaldan said:
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?
Click to expand...
Click to expand...
 
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
--

bbaldan said:
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?

Duane Hookom said:
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
--

bbaldan said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Thank you!!! It worked.

Duane Hookom said:
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
--

bbaldan said:
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?

Duane Hookom said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top