Results 1 to 4 of 4
  1. #1
    enquiries is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2013
    Location
    Samoa
    Posts
    69

    Setting and showing default value in a combo box


    Hi there,

    I'm trying to set and show a default value in a combo box - the setting part is easy, just how to show it. I've tried simple VBA in me.ComboBox.ItemData(1) but it doesn't show it when you type in new info into the field.

    Any help appreciated thanks

  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,953
    Don't understand the issue. Default value shows for me.
    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
    enquiries is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2013
    Location
    Samoa
    Posts
    69
    Not sure why it's not showing, in the Data section on combo box button property I set the default value and I've even tried setting it in the table but not working. I'll try deleting it and try again.

  4. #4
    enquiries is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2013
    Location
    Samoa
    Posts
    69
    Yub deleting it and adding it again - fixed it Just remembered only added default value after I added text box in form - so needed updated text box

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

Similar Threads

  1. Setting default value to zero in form box?
    By dekhelia in forum Forms
    Replies: 6
    Last Post: 10-17-2013, 08:53 AM
  2. Automaticly Setting Default Value
    By swicklund in forum Forms
    Replies: 5
    Last Post: 06-17-2013, 08:08 AM
  3. Setting Variable Default for Combo Box
    By gazaway in forum Forms
    Replies: 5
    Last Post: 04-08-2013, 10:32 AM
  4. Replies: 4
    Last Post: 11-04-2012, 10:46 AM
  5. Setting default vaulue?
    By djclntn in forum Forms
    Replies: 17
    Last Post: 04-12-2012, 11:20 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