473,404 Members | 2,137 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

Determine Combo Box Choices

Suppose I am exploring an unknown form programatically through VBA, and
I have run across a control I have determined is a combo box.

Is there a way to tell if the combo choices are restricted to list, and
can I tell what those choices are?

Nov 12 '05 #1
1 1174
LimitToList property (true/false) will tell you if it's restricted to the
list.

RowSourceType indicates if the source is a table/query, field list, or value
list.

RowSource indicate which ones.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John Baker" <ba*****@ix.netcom.com> wrote in message
news:hN*****************@fe2.columbus.rr.com...
Suppose I am exploring an unknown form programatically through VBA, and
I have run across a control I have determined is a combo box.

Is there a way to tell if the combo choices are restricted to list, and
can I tell what those choices are?

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: John Baker | last post by:
Suppose I am exploring an unknown form programatically through VBA, and I have run across a control I have determined is a combo box. Is there a way to tell if the combo choices are restricted to...
1
by: JRT | last post by:
I have a continuous form with 3 comboxes, combo1, combo2 combo3. The choices in combo2 are dtermined the what is selected in combo1 by using a where = combo1 statement. The combo is refreshed...
5
by: meganrobertson22 | last post by:
I have a simple form, frmProduct, with a combo box, cboStatus, that has 2 choices: "Active" and "Inactive." If I chose "Inactive," then I want another combo box to appear, cboInactiveStatus, which...
1
by: Smriti Dev | last post by:
Hi, I am looking for the 'Find a record on my form based on the value I selected in my combo box' but do not see it in the combo box wizard. How can I activate that to come up in the wizard or...
1
by: Steve B. | last post by:
Using VS 2003 1. I Connect to a MS-Access dB, create a DataAdapter (DA1) for Table1 and a DateSet (DS) with Table1 2. I populate a Datagrid and associated Textboxes (TB -Text) w/ the DS.DA1 -...
1
by: Dave | last post by:
I have a combo box in a asp.net datagrid - only problem is you have to click once to see it - and then click the arrow to see your choices I would like combo box to be visible - with the...
9
by: Mark Lancaster | last post by:
I have several combo boxes on form1 of my application. I do not know why, but the choices on my dropdownlist combo boxes no longer display when the form opens. They are there, because you can...
2
by: Doug | last post by:
Hi I have a list of about 50 text items (strings) that I would like to add to about 5 combo boxes at various times depending on if a user clicks on the OK button. I have tried to code an...
4
by: wideasleep | last post by:
Hello everyone, I am looking for a way to remove choices from cascading combo boxes as each selection is made. Here's how this is laid out. The initial combo box is STAGE and it will have...
4
by: gscott1 | last post by:
I am working with a large Access database and recently added a combo box to a form. The values that can be chosen from in the combo box are from a table I created with 6 possible choices. When I...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
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,...
0
jinu1996
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...
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.