Results 1 to 2 of 2
  1. #1
    Knaabis is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jun 2011
    Posts
    3

    How to set focus and mark ComboBox value by VBA?

    I have Form with ComboBox. This ComboBox has validation Rule.
    When i scan by barcode scaner wrong info, i get validation message and cursor is placed at end of scaned value.
    I can't scan one more time, because i need to mark all this wrong value manualy and only after that i can scan second time.


    How to set focus and mark this wrong scaned value by VBA?

  2. #2
    TOMMY.MYERS668's Avatar
    TOMMY.MYERS668 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Location
    West Virginia
    Posts
    77

    Re: How to set focus and mark ComboBox value by VBA?

    Pleae keep in mind ive had a long break from vba but three stab I would take woulf be an if statement.
    Like...

    If validation rule = failed then
    Input variable =null
    End if.


    Sorry I'm on my phone so I can't actually write it in code. But that should blank your input to allow it to scan again.

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

Similar Threads

  1. How to mark a thread as solved
    By Matrix in forum Forum Suggestions
    Replies: 10
    Last Post: 12-12-2019, 06:55 AM
  2. Replies: 0
    Last Post: 02-22-2011, 04:18 PM
  3. Mark the difference
    By zhshqzyc in forum Access
    Replies: 1
    Last Post: 01-28-2011, 08:49 AM
  4. How to make a Water Mark
    By newtoAccess in forum Reports
    Replies: 7
    Last Post: 12-06-2010, 04:13 PM
  5. Mark invoice paid
    By kylebmorris in forum Reports
    Replies: 1
    Last Post: 07-19-2010, 12:39 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