Changing report titles

Topic

New Reply

I have report titles ( Labels ) that change occasionally and I was trying to figure out if there was a was to change them without having to open up each report.

The particular example I have is a company name in the report or page header.

Seems like there should be an easier way.

Any suggestions?

Reply | Quote

Replies

You might try opening up the report(s)in design view and for a title use an existing field from the query or table from which the report gets its data. Something like a text box you could create in the report header that would have its date source set to =”Report”&” “&”ON”&” “&[CompanyNameField].

Hope this helps.

Reply | Quote

The simplest way to handle this is have a table that holds constant values like Company Name. I usually call the table something like USysSetup or tblDBConstants. It has two fields, ConstName and ConstValue. You enter a record for each “constant” you want to store, i.e., [ConstName] =”Company Name” and [ConstValue]=”My Company”.

Then you can use a user-defined function or a DLookup to retrieve the value to use in a textbox in the header of your report. That way the report updates itself when you change the value in the table.

Reply | Quote