report header

[lanelouna]

hello all
i tried this code and it give me error on the line (with bold font)

Set rprt = CreateReport
with rprt
.RecordSource = "ListY"
.Caption = "List_Y"
.Section(acDetail).Height = 500
.Section(acHeader).Visible = True
end with

can anyone tell me why?
is there a way to show the report Header in a report?
thank you
Lina

 

[scking]

I don't know what CreateReport does but it apparently returns a report object. Is this from a stored report? It so then why do you need to set the header visible in code rather than at design time?

You COULD place a breakpoint on the line that fails and run the report. When it stops, work on the problem in the immediate window.



-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------