Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Unanswered: Clearing selected text in combo box or text box

    Hi guys,

    I'm new to this website and only new to the database world. Can someone please tell me the VBA code for clearing text in either a combo or text box. I created a combo box on a form for users to select but when they come back to the form the selected text is still shows. Can someone please tell how to fix this problem.

    Hope someone out there can help me.

    Thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Code:
    Me.ComboBoxObjectName = ""
    or
    Code:
    Me.ComboBoxObjectName = Null
    However, it may be that you just need to clear the Control Source for the combo box too. It's hard to say because it's not clear what the combo box is being used for.

    Is the combo box meant to provide alternatives for a field in a table or is the combo box to give alternatives to be used in VBA coding only?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •