Conditional printing of fields

[Steve]

I have a report for a school in which I want to list each
student grouped by primary household last name with other
information (parent's name(s), phone #s, address under it
in a header with detail being the child or children at that
household.

Most children have both parents in the same household, but
many have one parent that they live with in one household
and another parent that lives at another address.

Right now the report looks something like:

-STUDENTLASTNAME HEADER-
[StudentLastName]
[PrimaryHousehold.ParentRelation]&[PrimaryHousehold.
ParentName]
[PrimaryHousehold.ParentAdress]
(etc. for Primary Household Info)
[OtherHoushold.ParentRelation]&[OtherHousehold.ParentName]
[OtherHousehold.ParentAdress]
(etc. for Other Household Info)
-DETAIL-
[StudentFirstName]&[DateOfBirth]

My question is: How can I get Access to not leave a blank
line when there is, (in the majority of cases) no Other
Household and no info to print.

Or phrased another way how can I surpress printing of
fields in the header?

Thanks much.

 

[Fons ponsioen]

Try the following:
Set the can shrink property for each of the textboxes to
yes and tha set the can shrink property for the report
band also to yes.
this shoul eliminate any blank lines, however if you have
labels adjacent to these textboxes the labels can not
shrink.
If applicable, to remove them I would do the following:
combine the label and the textbox data into one textbox,
make sure the textbox is not named the same as any of the
data elements, now in the new textbox enter;
="YourLabelText: "+[YourDataName]
If the [dataname] is null the label also will be null and
the textbox will shrink.
Hope this helps.
Fons

 

[Guest]

Fons:

That did the trick! (I had to add some IIf(IsNull ([field])
stuff but I can now surpress the lines I need to.

Thanks so much for your help

Steve

-----Original Message-----
Try the following:
Set the can shrink property for each of the textboxes to
yes and tha set the can shrink property for the report
band also to yes.
this shoul eliminate any blank lines, however if you have
labels adjacent to these textboxes the labels can not
shrink.
If applicable, to remove them I would do the following:
combine the label and the textbox data into one textbox,
make sure the textbox is not named the same as any of the
data elements, now in the new textbox enter;
="YourLabelText: "+[YourDataName]
If the [dataname] is null the label also will be null and
the textbox will shrink.
Hope this helps.
Fons

-----Original Message-----
I have a report for a school in which I want to list each
student grouped by primary household last name with other
information (parent's name(s), phone #s, address under it
in a header with detail being the child or children at that
household.

Most children have both parents in the same household, but
many have one parent that they live with in one household
and another parent that lives at another address.

Right now the report looks something like:

-STUDENTLASTNAME HEADER-
[StudentLastName]
[PrimaryHousehold.ParentRelation]&[PrimaryHousehold.
ParentName]
[PrimaryHousehold.ParentAdress]
(etc. for Primary Household Info)
[OtherHoushold.ParentRelation]&[OtherHousehold. ParentName]
[OtherHousehold.ParentAdress]
(etc. for Other Household Info)
-DETAIL-
[StudentFirstName]&[DateOfBirth]

My question is: How can I get Access to not leave a blank
line when there is, (in the majority of cases) no Other
Household and no info to print.

Or phrased another way how can I surpress printing of
fields in the header?

Thanks much.

.

.