Results 1 to 2 of 2
  1. 04-08-2012, 12:58 PM #1
    soulice
    soulice is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    16

    Switch combobox from multi back to single

    I am making some requested changes to someones db and one of the requests is to switch a combo box from "allow multiple values" to NO. Get an error that this switch to multiple values can not be undone. Thoughts? It is a value list and they want to leave it that way.
    Reply With Quote Reply With Quote
  2. 04-08-2012, 01:18 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Will have to create a new field, update it with the data from the original field, delete the original, rename the new field.
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Compliling multi step query into single query.
    By dandoescode in forum Access
    Replies: 1
    Last Post: 12-17-2011, 02:21 PM
  2. On click textbox inserts value back on combobox
    By whitelockben in forum Forms
    Replies: 2
    Last Post: 10-09-2011, 05:23 AM
  3. How to change multi-page form to single-page form?
    By Buakaw in forum Forms
    Replies: 4
    Last Post: 06-30-2011, 08:39 PM
  4. Linking Combobox back to table
    By jlclark4 in forum Forms
    Replies: 52
    Last Post: 12-31-2010, 03:18 PM
  5. Multi value field - Combobox help
    By stougch in forum Forms
    Replies: 0
    Last Post: 10-19-2009, 10:47 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums