Results 1 to 2 of 2
  1. #1
    LaughingBull is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    Jul 2015
    Location
    Toledo Ohio
    Posts
    143

    Access 2013 report data showing up as a number rather than a text

    I have a people table; Ethnicity Table; Program Type Table; Attendance Table.


    I enter the people into the people table then enter people into the attendance table with lookup for name from the people table and a lookup for program type from program type table and enter date attended. I then run a query on the attendance table to remove duplicates. I created a form from the attendance query there are 3 headers Program, Ethnicity, Name. but the program type comes up as the ID number and not the text name.
    The Ethnicity did the same thing but when I added the Ethnicity from the people table to the ethnicity header it show up as the name and I hide the box with the number but when I add the program type from the program type table to the program header is changes the source of the report to the program type table and then nothing shows up. It did not do that when I added the ethnicity type from the ethnicity table to the ethnicity header.
    Any ideas?




    Click image for larger version. 

Name:	Attendance Report print preview.jpg 
Views:	9 
Size:	59.1 KB 
ID:	21634Click image for larger version. 

Name:	Attendance Report.jpg 
Views:	9 
Size:	240.3 KB 
ID:	21635Click image for larger version. 

Name:	Attendance Table.jpg 
Views:	9 
Size:	55.6 KB 
ID:	21636Click image for larger version. 

Name:	Attendance Query.jpg 
Views:	9 
Size:	113.3 KB 
ID:	21637Click image for larger version. 

Name:	Program type table datasheet view.jpg 
Views:	9 
Size:	143.2 KB 
ID:	21638

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I NEVER build lookups in table because I want to see the actual value saved and not the lookup alias.

    Ethnicity control is showing as a combobox. It probably has the same setup as the combobox on form so it shows the alias.

    Either do the same thing with program or bind textbox to text field of Program Type table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-07-2015, 11:20 PM
  2. Number showing instead of text on a report.
    By GCtechjim in forum Queries
    Replies: 6
    Last Post: 01-10-2015, 08:14 PM
  3. Data Collection Access 2013
    By geraldk in forum Access
    Replies: 1
    Last Post: 05-26-2014, 12:28 PM
  4. Replies: 15
    Last Post: 02-14-2014, 01:27 AM
  5. Report TextBox printing ID Number, not text
    By ZipDoc in forum Reports
    Replies: 8
    Last Post: 02-01-2010, 12:30 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