Get Displayed Text of a ComboBox

Discussion in 'Access VBA Modules' started by David C. Holley, Jun 3, 2010.

  1. I've been playing with programically getting the text value of a ComboBox,
    but I keep getting an error message that the control has to have the focus
    in order to reference the .Text property. If I explicity set the focus, I'm
    able to get the value without any problems.

    Is this normal?
     
    David C. Holley, Jun 3, 2010
    #1
    1. Advertisements

  2. David C. Holley

    Rick Brandt Guest

    "David C. Holley" <David.C.Holley> wrote:

    > I've been playing with programically getting the text value of a ComboBox,
    > but I keep getting an error message that the control has to have the focus
    > in order to reference the .Text property. If I explicity set the focus,
    > I'm able to get the value without any problems.
    >
    > Is this normal?


    For Access yes. If you know the ordinal position of the column being
    displayed you can use...

    Me.ComboBoxName.Column(n)

    ....where n is the zero-based position of the column you want.
     
    Rick Brandt, Jun 3, 2010
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.