Results 1 to 7 of 7
  1. #1
    JHG is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2019
    Posts
    28

    Combo Box Text Info Not Displayed on report.

    The info that I have selected in the Combo Box does not show on the report. Only the number representing the specific info.

    If my Combo box options are as follow: - ABS


    PL
    and I select ABS, the number 1 and if I select PL the number 2 will show on the report. I suppose the report gets the info from the Table, because I noticed the same on the table.

    Is there a way to change this, because I need the actual either ABS or PL on the report.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    that means the bound column is set to an ID field, not the text field
    if the table is:
    1, bob
    2, sam
    3, sally

    and the combo is bound to col 1, shows 2 columns, but col 1 is invisible, users will only see col2: bob
    but the value assigned is 1.

    reports don't need to see a combo, they only need text boxes.
    the query should join to the lookup table and show col 2 of the combo box in the query too.
    The report will show this value.

  3. #3
    JHG is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2019
    Posts
    28
    I have various tables: -

    The info for the Combo Box is derived from these tables.

    Click image for larger version. 

Name:	Capture Tables.JPG 
Views:	15 
Size:	17.7 KB 
ID:	39328

    When one of these tables are open, it looks like this, This is the sizes table.

    Click image for larger version. 

Name:	Capture Sizes Table.JPG 
Views:	15 
Size:	22.2 KB 
ID:	39331

    These text of the sizes were supposed to be on the report and not the ID's.




    The main Table is the StockInfoTable
    Click image for larger version. 

Name:	Capture StockInfo Table.JPG 
Views:	16 
Size:	74.6 KB 
ID:	39329

    Here you can see that the ID's are being used.


    The Items Bound in the Design Tab
    Click image for larger version. 

Name:	Capture Bound items.JPG 
Views:	16 
Size:	83.5 KB 
ID:	39330

    If I hide the ID fields, will it correct the problem or should I re-do the whole DB and maybe not give the tables ID's?

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What is the recordsource of the Report?

  5. #5
    JHG is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2019
    Posts
    28
    StockInfoT Table

  6. #6
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    The report needs a new query as its recordsource. In query design, add the table StockInfoT Table and all the other tables that include size, type, included, etc. In the query design grid, drag down the text fields for size, type, included, etc. Don't pull down the IDs, as you don't want to see them in the report. Run the query and you'll get the idea.
    Last edited by davegri; 08-06-2019 at 09:51 AM. Reason: clarif

  7. #7
    JHG is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2019
    Posts
    28
    Thank you this is working.
    Now I must get this query in a report

    Click image for larger version. 

Name:	Capture StockInfoQ.JPG 
Views:	12 
Size:	65.4 KB 
ID:	39332

Please reply to this thread with any new information or opinions.

Similar Threads

  1. # Error displayed in Text Field
    By willfrank in forum Access
    Replies: 5
    Last Post: 07-05-2016, 09:19 AM
  2. Generating a report from info in a combo box
    By sarahchadwick74 in forum Reports
    Replies: 1
    Last Post: 04-27-2015, 09:50 AM
  3. Replies: 7
    Last Post: 10-25-2014, 10:41 AM
  4. Replies: 1
    Last Post: 08-09-2014, 04:01 PM
  5. Replies: 1
    Last Post: 07-12-2012, 12:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums