Edit Report Objects at Run Time

  • Thread starter Thread starter Todd Heiks
  • Start date Start date
T

Todd Heiks

MSA 2003

I need to make a dynamic report where the column headers, text box control
sources, and the number of columns change.
Is there a way to create a MSA report in code?
Is there a way to edit report objects w/o a macro?

Is there a way to create an *.RTF file w/o using MS Word? (Looking for
inexpensive)

Regards,
Todd
 
Todd Heiks said:
MSA 2003

I need to make a dynamic report where the column headers, text box control
sources, and the number of columns change.
Is there a way to create a MSA report in code?
Is there a way to edit report objects w/o a macro?

Is there a way to create an *.RTF file w/o using MS Word? (Looking for
inexpensive)
Click to expand...


The answer to all those questions is Yes. However the devil
is in the details.

A dynamic report is manipulated by using VBA code in the
report's Open event to set control properties (e.g.
ControlSource, Left, Visible, etc). Typically this is done
by designing the report with all the controls you will ever
need and making them invisible. Then they will exist and
can be manipulated at run time.

OTOH, I have a feeling that you may be trying to deal with a
crosstab query. If that's the case, take a look at the
examples at:
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

You can create/modify a report using a VBA procedure, BUT
this is a design time activity. This rules it out of your
question about doing it at run time.

I can't help you with the RTF part of your question, but see
the free RTF stuff at www.lebans.com
 
Back
Top