Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    kleaverjr is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Apr 2022
    Posts
    53
    Quote Originally Posted by CJ_London View Post
    Listboxes are intended to show a list and highlight the selected row so the user knows which row is selected. It is just the way they work and there is nothing you can do about it. Change to a combo or spinner control as WGM suggests
    I don't see it listed under the Controls for Access 2013 unless I don't have some kind of option selected that gives me that kind of control. :-\

  2. #17
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    The spinner control is one of the built-in ActiveX controls - Microsoft Forms 2.0 SpinButton
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #18
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,413
    That is a listbox, just reduced in vertical size to one row.
    To clear the white-on-black (which is simply the selected row), add this sub to the form:

    Code:
    Private Sub lstbxManualEntryItemQty_AfterUpdate()
        Me.lstbxManualEntryItemQty = ""
    End Sub

  4. #19
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    problem with that is the listbox now does not have a value - it might be displaying something, but multiply by the price - what do you get?

  5. #20
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,654
    Roll you own with a couple of buttons and a textbox.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  6. #21
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,413
    Quote Originally Posted by CJ_London View Post
    problem with that is the listbox now does not have a value - it might be displaying something, but multiply by the price - what do you get?
    Well, you gotta do what needs be done with the selection before the unselection.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Theme, colors
    By lefty2cox in forum Access
    Replies: 1
    Last Post: 03-07-2021, 09:08 AM
  2. Replies: 8
    Last Post: 02-07-2021, 05:29 AM
  3. Replies: 4
    Last Post: 05-30-2016, 10:53 AM
  4. Replies: 12
    Last Post: 01-08-2014, 05:15 PM
  5. Globally changing colors on forms
    By pwdpwd in forum Programming
    Replies: 2
    Last Post: 11-23-2010, 09:06 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