Solved

MS Access - Setting a Report Header label value

Posted on 2011-03-01
2
299 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 - Access MVP) earned 500 total points
Comment Utility
Use DLookup() as the Control Source for a textbox (instead of label):

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

mx
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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

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 article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

762 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

12 Experts available now in Live!

Get 1:1 Help Now