Re: Subreport name appears behind data



when you create a subreport within a main report, the subreport is a
*control* which has a label attached to it (same as a subform control
created in a form). if you just "grabbed" the subreport control within the
main report, and dragged it, the attached label would move along with it. so
if the label is "behind" the control, you're still not going to see it.

try 1) resizing the subreport control, to see if the label is behind it, or
2) in the Object listbox on the toolbar, choose each object in turn to and
look at what object is selected in the report, to see if you find a "hidden"
label.

hth


"Donna" <Donna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9A67BC7E-C1C3-48D8-8116-CCD37FDF05F5@xxxxxxxxxxxxxxxx
I have a main report for job quote information
I have a subreport listing the product details used on the particular job
The subreport name is "quote subform".
everything works fine EXCEPT the words: "Quote Subform" appear behind the
first line of data. I have the report header and page header on the
subform
set to visible: NO. The first thing that is visible is the Manufacturer
header. It is behind this that the words appear.
I have moved all of the controls around to see if I can find a label field
hidden behind something, but I am not finding it. I tried to move the
entire
subreport around to see if it is behind the subreport somewhere. I think
it
is somewhere on the main report rather than the subreport, but I am not
finding it. How do I get it to not print the name of the subreport? How
do
I find the label?


.



Relevant Pages

  • Re: Is this a Sound Database Design? -- code: SwitchTabs
    ... The "command buttons" (put in quotes because I actually used label ... Dummy is an unbound control -- really tiny because I use labels instead ... Sometimes, the subforms do not have linking fields, like a lookup subform ... Dim mCurrentTab As Integer, i As Integer, mBoo As Boolean ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is this a Sound Database Design? -- code: SwitchTabs
    ... The "command buttons" (put in quotes because I actually used label controls) to switch subforms are colored so that you can see which one is active ... TabID is an unbound control -- it is set when the form loads ... Sometimes, the subforms do not have linking fields, like a lookup subform ... Dim mCurrentTab As Integer, i As Integer, mBoo As Boolean ...
    (microsoft.public.access.tablesdbdesign)
  • Re: IIf or Nz function
    ... If it is a report with a subreport, ... If it is a form with a subform, ... referring to the non-existent control in the subform ... If it is in fact a report with a subreport, ...
    (microsoft.public.access.forms)
  • Re: subreport and null value problem
    ... >about the label control. ... >events or control source. ... Format event of the **section** containing the subreport. ... When the report is viewed stand- ...
    (microsoft.public.access.reports)
  • RE: report/subreport
    ... What I did was use iif and iserror to test textbox on subform, ... the main report has no records and ... the subreport has a text box that references a value from a text box on ... what is the control source of the text box on the main report? ...
    (microsoft.public.access.reports)