J
JHL
Is it possible, without hardcoding, to have the table name print in the
report header or anywhere in a report?
Thanks for any help.
report header or anywhere in a report?
Thanks for any help.
Allen Browne said:If the report gets its data from this table, you could display it in a text
box with Control Source:
=[Report].[RecordSource]
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to the newsgroup. (Email address has spurious "_SpamTrap")
JHL said:Is it possible, without hardcoding, to have the table name print in the
report header or anywhere in a report?
JHL said:Either I don't quite understand your reply or this method doesn't work.
The report will get it's data from a table, not a query.
In the report header, I added a text box and the code you suggested (in the
control source) and nothing appears?
Allen Browne said:If the report gets its data from this table, you could display it in a text
box with Control Source:
=[Report].[RecordSource]
Allen Browne said:Works here.
JHL said:Either I don't quite understand your reply or this method doesn't work.
The report will get it's data from a table, not a query.
In the report header, I added a text box and the code you suggested (in the
control source) and nothing appears?
Allen Browne said:If the report gets its data from this table, you could display it in a text
box with Control Source:
=[Report].[RecordSource]