Determine Combo Box Choices

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • John Baker
    #1

    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?

    Tags: None
    • Allen Browne
      #2
      Re: Determine Combo Box Choices

      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" <baker-j@ix.netcom.com > wrote in message
      news:hNCkc.5046 $Gq1.2683@fe2.c olumbus.rr.com. ..[color=blue]
      > 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?[/color]


        Comment

        Previous template Next
        Working...