?
Solved

MS Access - Setting a Report Header label value

Posted on 2011-03-01
2
Medium Priority
?
312 Views
Last Modified: 2012-06-22
I have a report that is based on a Query.  I have a separate table that contains the Page header labels I want to use.  How can I query the separate table (not related to the content of the report) to set the Caption value of the label?
0
Comment
Question by:keschuster
2 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 35012374
Use DLookup() as the Control Source for a textbox (instead of label):

=DLookup("[YourFieldName]","YourTableName")

mx
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35012378
how are the label information stored in the table? does it have id to distinguish them from each other?

post sample data...

you can create a function to get the correct label,
by passing a parameter to the function
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

850 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