Enumerate sub and subreport controls

  • Thread starter Thread starter Sam Davis
  • Start date Start date
S

Sam Davis

Hi All,

I'm sure somebody out in the ether has done this before. Its giving me a
headache!

I have a complex report that contains many sub reports and sub sub reports.
I need to be able to alter the font settings on textboxes on all of these
reports based on font info I have stored within a table.

I've been trying without success to enumurate through all textbox controls
on a report including all controls on any sub (or sub sub...) reports. It'll
be a recursive procedure...

Any ideas or links that may help?

Thanks,
Sam
 
Hey,

Have you tried the documenting tool?

I am not sure about the exact path, ('cause my Access is in French), but it
should be in something like "Tools, Analysis, Documenting"... And try the
advance options to choose the exact info you want for each control.
 
You might include what code you are using to do this. Then someone might be
able to suggest a modification to your code.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
OOps... sorry, I did not understand you were trying to programmatically
change the format, I thought you only wanted a list of your controls...

*dumb me* :-p
 
Back
Top