Change report from outside ?

  • Thread starter Thread starter Stuart Crow via AccessMonster.com
  • Start date 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
 
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.
 
Back
Top