Description displaying on Report

Posted on 2011-10-03
Last Modified: 2012-05-12
I have a field that is a listbox on the form.  It stores the CODE but displays the DESCRIPTION.  

I'm making a report, for this field, I want to display the DESCRIPTION but the report field is showing the CODE (because that's what's stored in the field).  

On the report, I turned the field to a list control on the subform (which sits on the report), linking to that list and it's displaying the DESCRIPTION but it's also showing the dropdown arrow from the list... how do I make the data display in a textbox or get rid of the arrow on the list since this is a report.
Question by:gcgcit
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    Another reason to convert the form to a report (see my original response to your previous post).

    I don't know of anyway you can programmatically change the control type of a control on the subform that is embedded in your report.

    If you create a report, I would join that field "Code" to the table that is now the rowsource of your listbox, then I would add the [Description] field to the query that is the recordsource for the report.
    LVL 26

    Expert Comment

    Agreed with @fyed.
    I saw your first question a little earlier.
    Create a subreport object!

    It's not hard.  Add a new report in design view, open your subform in design view
    Copy all the objects from the subform, paste them on the the report.
    Open the recordsource of the form, Save as a new query.
    Tweak it.  Every combobox on the form can be a join in the report query and then just a textbox.

    Although some Experts have disagreed with my adamance, reports are for printing, forms are NOT
    LVL 47

    Accepted Solution


    Don't remember how easy it was in 2003, but in 2007, you can open the form in design mode and then do a Save As.  When you do this, you can select whether you want to save it as a report or as a form.
    LVL 26

    Assisted Solution

    That works in A2003, but I've never tried it until just now.
    It keeps the exact look of the form, and usually you're trying to match the main report's look.
    But it is doable too.
    Depending on the source form it may be less work than a copy-paste

    But from the earlier question, I agree with @fyed that there is little point in putting code into a form to make it behave like a report.
    Just create the report!

    Author Comment

    I just started using 2007 - that was pretty easy to convert to a report so I did.  Looks great. Thanks guys!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    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…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now