Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / February 2008

Tip: Looking for answers? Try searching our database.

Text on a report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Selby - 11 Feb 2008 16:54 GMT
I know this should be simple, but I can't add a text box to an existing
report.  When I add the text info and try to run the report it comes up with
a Parameter Value box that wants info.  

What I am trying to do is put text on a report that will always print on
that particular report.  What is the correct way to do this?  Thanks in
advance.
Tom Lake - 11 Feb 2008 17:32 GMT
>I know this should be simple, but I can't add a text box to an existing
> report.  When I add the text info and try to run the report it comes up with
[quoted text clipped - 3 lines]
> that particular report.  What is the correct way to do this?  Thanks in
> advance.

You don't want a text box (which needs a data source).  What you need is a label.
That's just a box with text in it.

Tom Lake
Selby - 11 Feb 2008 17:40 GMT
Thanks so much - I knew it was probably simple....

> >I know this should be simple, but I can't add a text box to an existing
> > report.  When I add the text info and try to run the report it comes up with
[quoted text clipped - 8 lines]
>
> Tom Lake
fredg - 11 Feb 2008 18:01 GMT
> I know this should be simple, but I can't add a text box to an existing
> report.  When I add the text info and try to run the report it comes up with
[quoted text clipped - 3 lines]
> that particular report.  What is the correct way to do this?  Thanks in
> advance.

Who says you can't add a text box to a report?

Add an unbound text control to the report.
Set it's control source to something like:
="This is my text."
The above text will always print on the report.

If you use
= [Enter your text]
you will be prompted to enter the text.
What ever you enter will appear on the report.
=
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Tom Lake - 11 Feb 2008 18:07 GMT
>> I know this should be simple, but I can't add a text box to an existing
>> report.  When I add the text info and try to run the report it comes up with
[quoted text clipped - 10 lines]
> ="This is my text."
> The above text will always print on the report.

Yeah, but why waste the extra resources with a text box
when a label control will display text without the overhead?

Tom Lake
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.