Solved

MS Access Text Box Control Source Uses an Input Box--one input, all report pages...

Posted on 2006-07-18
3
304 Views
Last Modified: 2011-09-20
I created a basic report in MS Access 2003.  The footer (a text box) on the report is typed in each time the report is generated using an input box.  It is working fine, except that it asks for input (footer text) for each individual page of the report instead of asking for it once and printing it on all of the pages of the report.

In the control source for the text box, I have the following:

=InputBox("Enter the string you want to print in the footer below or leave blank if you don't want anything to print:","Footer Text","")

Can anyone help?  I'm not very advanced in my Visual Basic skills so more detail is better than less...

Thanks.
0
Comment
Question by:pmarcella
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 125 total points
ID: 17130555
Try this.  Move the textbox to the main body of your report and set it invisible.  Then create another textbox in the footer and set it's source equal to the textbox in the body and see what happens.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17183674
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now