Results 1 to 3 of 3

Thread: combobox

  1. #1
    Join Date
    Apr 2004
    Posts
    100

    Unanswered: combobox

    given a sql statment like:
    select a,b,c form table
    bound to a combobox.

    How can I set whether a,b or c is displayed in the combobox?
    Is it possible to display a and b?
    Thanks a lot!
    Pregards,
    Proximus

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Proximus
    given a sql statment like:
    select a,b,c form table
    bound to a combobox.

    How can I set whether a,b or c is displayed in the combobox?
    Is it possible to display a and b?
    Thanks a lot!
    Pregards,
    Proximus
    Well the way you have this query constructed, A,B, and C are only visible is you have a non-zero column width for each of them...

    So in the combobox properties check the Column Width setting ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    You can concatenate the fields like

    SELECT A, B, C, [A] & [B] AS D

    Then in column widths...set appropriate widths to 0".

    This thread may help: http://www.dbforums.com/showthread.php?t=984982

    HTH,

    Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •