Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2006-07-18
3
Medium Priority
?
319 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

721 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