Is there a way to morph a Subreport?

  • Thread starter Thread starter Boricua
  • Start date Start date
B

Boricua

Hello All,

I'm kind of new to VBA code in Access, and I would like to know if there is
any way that you can "morph" a subreport so that the first line in the report
will print different that the remaining ones. I am making a cascaded diagram
(similar to a "tree") that include some blocks and arrows to "show" the
relations between my fields. I want ot be able to show somehow that the
second, third, and so forth lines in my subreport derive from the first one
by detecting which line is the first in my report and make visible a
different arrow shape for all lines following the first one by taking
advantage of the .visible property of the fields and other objects (arrows &
boxes) used in my report.

I was able to label the lines sequentially, but when I try to use the
"linenum" (this is the name of my text box) control I'm always getting the
same value ("1"), so I have not been able to determine which is the first
line of my report and then adjust the .visible property of the objects used
accordingly. What kind of recordset or data structure (an array?) does
Access use to logically represent or internally store the lines/rows when a
subreport is being created?

Any help will be much appreciated.
 
Have you looked at Report grouping, a reporting concept, not VBA.

Line 1 would be a group header and lines 234 would be detail lines of the
group.

You would need a column in your table indicating which group the detail
lines are part of.



Alan
 
Back
Top