Results 1 to 2 of 2
  1. #1
    khayward is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Apr 2017
    Location
    Oregon
    Posts
    89

    Clear combobox on click


    I have a combobox on a form that is going to be used a lot. I'd like for the box to clear when clicked on to begin looking for a new record, I'm new to macros and such, I know next to nothing. I looked through the stock options and couldn't see anything that looked like ti would do this. Is there a way to do this?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    In VBA you'd set it to null or "". In a macro I think you'd use SetProperty and set the value.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Clear the Combobox using a button
    By CharissaBelle in forum Forms
    Replies: 2
    Last Post: 04-28-2016, 01:24 PM
  2. clear field on click event
    By raffi in forum Forms
    Replies: 3
    Last Post: 02-04-2015, 03:56 PM
  3. Combobox drop down on click
    By ashu.doc in forum Forms
    Replies: 2
    Last Post: 09-19-2012, 08:02 PM
  4. Change fields based on a combobox click
    By Richie27 in forum Programming
    Replies: 5
    Last Post: 05-31-2012, 08:01 AM
  5. On click textbox inserts value back on combobox
    By whitelockben in forum Forms
    Replies: 2
    Last Post: 10-09-2011, 05:23 AM

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