Table Name

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.
 
A

Allen Browne

If the report gets its data from this table, you could display it in a text
box with Control Source:
=[Report].[RecordSource]
 
J

JHL

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?
 
A

Allen Browne

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]
 
J

JHL

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top