Using a  listbox to select as you scroll

Posted on 2003-02-28
Medium Priority
Last Modified: 2012-08-13
I am using a listbox to set the number of copies to print of a report.
I would like to have the value showing rather than the value selected to be the value used.
Do I have the selected value programatically change when a scroll button is pushed or is there a method of determining what is showing vs what is selected.
Question by:Nobert
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 41

Expert Comment

ID: 8042985
I'm not sure I understand why you are using a list box. What values does it store ?

You can refer to the displayed value by using:
Me!MyListBox.Column(1) (if the displayed value is the second column of the listbox data)
LVL 44

Accepted Solution

Arthur_Wood earned 150 total points
ID: 8043283
what you want to use is a SprintButton control, and an associated TextBox.  Make the orientation VERTICAL.

In the SpinButton_Change() event:

txtValue.Text = SpinButton1.Value

the value is increased when the UP arrow or the SpinButton is clicked, and decreased when the DOwn Arrow of the SpinButton is clicked.  You can set the Upper and Lower limits for the SpinButton, either in code, or as  design-time Properties (Max and Min values)


Author Comment

ID: 8044468
Thanks. Took a while to find the spinbutton control and the event is a spinbutton_updated() but it all works now.
LVL 44

Expert Comment

ID: 8044496
good to see that you figured it out.


Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question