Change report from outside ?

  • Thread starter Stuart Crow via AccessMonster.com
  • Start date
S

Stuart Crow via AccessMonster.com

Hello
I am at present working on an app written in Access 2002 which
contains a few reports. The app is to be extended, and I would like to
be able to reuse these reports. There is no problem with changing the
query to get the data using Me.Properties("RecordSource").Value on
report_open. To reuse the reports, though, I need to change a text
field within the report, ie. there is a text field called txtHeading
which has a text string in it, and in the properties for this
txtHeading there is ControlSource="...." - the text string.
Is it possible to change the text in this txtHeading on report_open ?
Or if not, is there any way that this can be done ?
TIA
Stuart
 
D

Duane Hookom

If txtHeading is not bound (no value in the control source), you can set the
value in the On Format event of the section containing the control.
 
Top