View Single Post
  #7  
Old April 19th, 2010, 05:26 PM posted to microsoft.public.access.reports
Access infant
external usenet poster
 
Posts: 14
Default drawing excel like grids on access reports

Thanks a lot for the code. But i have been saying that i have controls in the
group headers and footers for each control in the detail section. for
example if i have three controls x,y,z i have unbound controls in the page
footer, report footer,other groupfooter to show the totals at various level
for each control viz. x,y,z. So, if i follow your code and suppose control X
changes in size(because of the can grow property), i cannot see the same
change in the unbound controls displaying total for x. So, there is no
guarantee that the lines look like grids because they do not fall on a
straight line. To work this around, can i store the Left property of each
control in the detail section in a module level variable and use the same
wherever i want to use ctl.Left.
Any how i want to draw only vertical lines. Please suggest me if it is
possible?

Or to follow your code as it is, probably i need another piece of code to
make sure that the ctl in the detail section and the corresponding ctls in
the different sections have same left property and width property. If you
think this is better, could you tell me how to ensure this
--
from
chanakya
Baruva