Results 1 to 5 of 5
  1. #1
    jlgray0127 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Central Illinois
    Posts
    193

    Access 2010 multi value fields and forms

    Has anyone used multi value fields in a table? This is a new feature in access 2007 and 2010.
    I tried it out, but am having issues displaying the value in a form. I see the ID#, but not the common name I'd like to see.
    I'm not sure where to change the properties on this. I've looked all over the internet, and really have found no help.

    To make sure I explained what I was looking for, I have a tableA, with FacilityId, and Facility, Location, and Building. I set tableB up with a lookup field, which is looking at tableA to pull the facility. When you select the combo box on tableB, it drops down and displays the data from Table A, just like a combo box. You have your list and check boxes. Select the facilities you want to choose for your record, and it displays them, as Fac1, Fac2, Fac3.
    I can create a query against tableB and it displays the value the same way Fac1, Fac2, Fac3. When I create a form, however, it shows 1, 2, 3.
    I can not find anywhere to change the combo box's properties to show Fac1, Fac2, Fac3, rather than the ID, 1, 2, 3.

    Any help is greatly appreciated.



    Thank you!!!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I REFUSE to use multi-value fields because they are such a headache. However, no problem showing the related descriptor value with properly set up combobox.

    What are the combobox settings for properties:

    ControlSource
    RowSource
    BoundColumn
    ColumnCount
    ColumnWidths
    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.

  3. #3
    jlgray0127 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Central Illinois
    Posts
    193
    ControlSource = Facility, which is the field in the table.
    RowSource = Is not populated
    BoundColumn = 1
    ColumnCount There is no column count property (very puzzled of this. It is on the table's lookup properties, but not the form's property sheet)
    ColumnWidths Same as above.
    Attached Thumbnails Attached Thumbnails Capture.PNG  

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Look on the Format tab.

    Will need the same settings as in the table, including RowSource.
    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.

  5. #5
    jlgray0127 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Central Illinois
    Posts
    193
    That fixed it!
    I do not care for these either. I do not believe I will use them, again, in the future.

    Thanks for your help, once again!!!!

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

Similar Threads

  1. Multi Search Form in Access 2010 Issues
    By AccessJunky in forum Access
    Replies: 4
    Last Post: 08-23-2019, 11:02 PM
  2. Access 2010 Multi Info Inside Field!!
    By edmund2145 in forum Access
    Replies: 3
    Last Post: 07-05-2013, 08:35 PM
  3. Replies: 1
    Last Post: 01-12-2013, 07:46 AM
  4. Access 2010 - Multi Currency
    By Jismaeel in forum Access
    Replies: 1
    Last Post: 12-20-2010, 03:56 PM
  5. Querying Multi Line Text Box in MS Access Forms
    By spindlebeakin10 in forum Queries
    Replies: 5
    Last Post: 12-09-2010, 05:50 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