Determine Combo Box Choices - Microsoft Access / VBA

John Baker

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

Subscribe Post Reply

1352

Allen Browne

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

Similar topics

Determine Combo Box Choices

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...

Microsoft Access / VBA

filling combo box based on previous combo

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...

Microsoft Access / VBA

Invisible Combo Box

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...

Microsoft Access / VBA

combo box choices

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...

Microsoft Access / VBA

Combo box Help

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 -...

C# / C Sharp

vb.net combo boxes choices no longer visible

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...

Visual Basic .NET

fill three combo boxes

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...

C# / C Sharp

Removing choices from combo boxes

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...

Microsoft Access / VBA

Combo box with a red border

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...

Microsoft Access / VBA

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

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...

Computer Hardware

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice