Table Name

  • Thread starter Thread starter JHL
  • Start date Start date
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.
 
If the report gets its data from this table, you could display it in a text
box with Control Source:
=[Report].[RecordSource]
 
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 - 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?
 
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]
 
Tried one more time and your correct.
THANKS....
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]
 
Back
Top