subreport problem

[Guest]

need info about subreport
1. subreport disappear when there is no data in field when search by date .
2.and also when there is null value in subreport it also not show any data.

 

[Duane Hookom]

You have described what happens but left without any idea of what you want
or expect.

--
Duane Hookom
MS Access MVP

need info about subreport
1. subreport disappear when there is no data in field when search by date ..
2.and also when there is null value in subreport it also not show any

data.

 

[Evi]

Did you want something to appear to show where the subreport is, even when
the subreport has no data in it? The subreport is supposed to disappear when
it has no data because that's what most people would want but I can imagine
times when you would want it to show, even if it is blank. You'd have to
fake it by creating a rectangle around the place where the subreport is and
having that appear and disappear. (It needs to be invisible when the
subreport has data because it can't Grow/Shrink)

(You can use HasData in the On Format Event of the section that holds the
subform


If Me.RptGotNoDataSub.Report.HasData Then
Me.Box1.Visible = False
Else
Me.Box1.Visible=True
End If

Put the subreport's labels into the main form.
Evi

need info about subreport
1. subreport disappear when there is no data in field when search by date ..
2.and also when there is null value in subreport it also not show any

data.