Results 1 to 2 of 2
  1. #1
    jj1 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    128

    Text Box Printing Combo box ID instead of text Value

    I am trying to print on report
    the value of combo box which is based on the query
    SELECT qryDept.DeptID, qryDept.Department
    FROM qryDept;
    with formula
    =[Form]![FormName]![comboboxName]
    But my problem is its printing ID of the combo box instead of text value which is name of the dept. say HR

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,967
    Refer to the column the name is in. Column index begins with 0.

    =[Form]![FormName]![comboboxName].Column(1)

    Do you have a Departments table? Why does RowSource pull from query and not table? Can't you include Departments table in the report RecordSource?
    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. Text Box missing sides when printing
    By ryan.boyle in forum Reports
    Replies: 2
    Last Post: 02-15-2013, 11:08 AM
  2. Replies: 3
    Last Post: 02-07-2013, 09:53 PM
  3. Replies: 2
    Last Post: 08-16-2012, 10:02 PM
  4. Replies: 1
    Last Post: 05-24-2012, 04:59 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