Access 2007 Report Showing ID (Primary Key) - How Can I Show Value?

Posted on 2009-12-28
Last Modified: 2013-11-29
I have a database with a handful of tables (all with a auto-number primary key). When producing reports from this I get the ID in the report rather than the value - how can I change this to display the value rather than the ID? (The query shows the actual value rather than the ID...)

I can't upload an example as it's Access 2007 and it's not allowed :-(
Question by:stehardy88
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    Use that field from the query as the Control Source for the text box which is now displaying the ID.

    LVL 8

    Author Comment

    The Control Sources are set as the correct fields. The record source for the Report is the Query.

    I've stripped down and saved as Access 2003 version - please fin attached.

    Ayy help would we gratefully welcomed.
    LVL 31

    Expert Comment

    If this is a case where a field has a lookup to another table, you can place a combo box on the report to display the looked-up value instead of the key field.  (It will look like a textbox in Report View or Print Preview).  I tried to open your report, but just got a message "can't open Contact.png".
    LVL 31

    Accepted Solution

    Alternately, you can link in the tables that have the fields you want to display on the report, and then place those fields directly on the report.
    LVL 8

    Author Closing Comment

    Linked in fields from 4 tables that were causing problems. Changed the RecordSource to these fields in the query - started working correctly.


    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

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    731 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

    19 Experts available now in Live!

    Get 1:1 Help Now