Howdy all.
This may have been covered previously but I've had no success in
retrieving it...
Where may I find what the limitations are of the various controls, i.e.
number of records/items that can be displayed in a dropdown combobox.
In Paradox, this is 2500 items.
If, for instance, a customer table has more than the limitation, I'm
looking at somehow displaying a table containing the alphabet such that
when the user clicks on a letter that the combobox is filled with only
the customer names for the letter selected. Think this would overcome
the combobox limitation unless the number of customers for the letter
max the limitations.
Thank,
Rey
2  3481 
Rey,
I think that the number of items that are allowed in the combobox is a
factor of memory. I don't remember there being a limit to the number of
items.
However, there is such a thing as a practical limit. 2500 (which I am
sure the combobox can handle), is way too large to be practical in any way.
If anything, you should use some other method to display this choice to the
user (the one that you gave was pretty good actually).
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m
"Rey" <re********@cox .net> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com... Howdy all.
This may have been covered previously but I've had no success in
retrieving it...
Where may I find what the limitations are of the various controls, i.e.
number of records/items that can be displayed in a dropdown combobox.
In Paradox, this is 2500 items.
If, for instance, a customer table has more than the limitation, I'm
looking at somehow displaying a table containing the alphabet such that
when the user clicks on a letter that the combobox is filled with only
the customer names for the letter selected. Think this would overcome
the combobox limitation unless the number of customers for the letter
max the limitations.
Thank,
Rey
> > ... looking at somehow displaying a table containing the alphabet such that
...
But watch out for internationaliz ation/localization issues when you take
this approach.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:u4******** ******@tk2msftn gp13.phx.gbl... Rey,
I think that the number of items that are allowed in the combobox is a
factor of memory. I don't remember there being a limit to the number of
items.
However, there is such a thing as a practical limit. 2500 (which I am
sure the combobox can handle), is way too large to be practical in any
way. If anything, you should use some other method to display this choice to
the user (the one that you gave was pretty good actually).
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m
"Rey" <re********@cox .net> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com... Howdy all.
This may have been covered previously but I've had no success in
retrieving it...
Where may I find what the limitations are of the various controls, i.e.
number of records/items that can be displayed in a dropdown combobox.
In Paradox, this is 2500 items.
If, for instance, a customer table has more than the limitation, I'm
looking at somehow displaying a table containing the alphabet such that
when the user clicks on a letter that the combobox is filled with only
the customer names for the letter selected. Think this would overcome
the combobox limitation unless the number of customers for the letter
max the limitations.
Thank,
Rey
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: CJ |
last post by:
Patients-physician-querry
relational database with 2 tables, physicians and Clients,
In the Client DB, there is a number that implies the physician,
I can easily make a form where you put in the physicians number,
but..
If I want the dropdown box to show the name of the physician I have to
base it on the other table. (the physician table),...
|
by: Nicolae Fieraru |
last post by:
Hi All,
I am trying to change the rowsource of a combobox when I click on it. I
played with many events, associated with the form and the combobox, but
still haven't figured out what is the way of doing it.
I have a table with products, tblProducts, some of them are Active while
others are Inactive.
The form shows all the products...
|
by: Norm Katz |
last post by:
When you use a bound combobox and you set its dropdown style to "dropdown"
that allows you to enter text in the edit box. But if you enter anything
other than a value in the current bound items collection, the .text property
does not update. Furthermore, you can't easily trap an event to examine the
new value if your program assigns it...
|
by: Peter Stojkovic |
last post by:
VB 7.1 and windows.forms.
I have a comboBox on a form.
When the user goes with TAB-Key to the comboBox,
the comboBox should dropDown the ListBox automatically
and show ALL entries.
The user has no possibility to use a mouse !!
How can I program a automatic dropDown ( Showing all entries ),
if the user tabs to the comboBox ???
|
by: Gil |
last post by:
Is there a way to tell if a combbox is in dropdown mode.
I tried and if statement combobox.dropdown = true
but i get an error. dropwndown function doesnt store if its true or
false
what i am trying to do is make an autoscroll combobox. like you have on
html textbox's, but this time you hit enter for a change to be made. i
do this because i...
| | |
by: Harry |
last post by:
I have two tables in a database. One fills the drop-down and the other
records the selection. Filling the dropdown with another table seems to be
breaking the binding with the table it records to. VS2005 with SQL2005.
I have a lot of these to do, and don't want to hard code each box. I can
drop and drag the table elements to the form and they...
|
by: Vidhura |
last post by:
My application contains 2 tabpages.The second tabpage contains panel .The panel contains series of combobox and textboxes.
If the item not selected in combobox and the user click on the another tabpage,it should show "The option from dropdown should be selected" and focus the combo .I have did this in validating event
it works fine till...
|
by: Andrus |
last post by:
SWF DataGridView contains combobox control.
Activating combobox and pressing F4 to open dropdown menu causes strange NRE
(see below).
When I enter some valid value to combobox, press tab, shift+tab , 44
dropdown menu opens OK.
How to fix ?
How to use VCSE 2008 with .net framework source code to find the line in
|
by: rfdjr1 |
last post by:
I'm using Access 2000. I have a raher simple database of my CD collection, with
just three fields, Artist, Album Title and Type of Music. While going to update
it today with a couple new CD's, I noticed that if I sort alphabetically by
Artist it have 387 records but if I sort by Album Title it shows 393 records.
Any idea why this would be? ...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
