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

  2. David C. Holley

    Rick Brandt Guest

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


    ....where n is the zero-based position of the column you want.
    Rick Brandt, Jun 3, 2010
    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.