Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    110

    Question Unanswered: How to enter data as a number but it will code to combo box listing?

    Hello Everyone,

    I am trying to code my combo boxes to accept a number and then show it as it is in the list. Example County is Alachua, but will be entered as 11, or 09 for September... How to I set it to know that a entry of 09 will display September?

    Thanks in advance..
    Chris

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Combo Look

    Have a look at the form called: CountyComboBoxSample in this attachment. It uses 2 different samples.
    Attached Files Attached Files
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    What I Do is add the Number feild and the text to be display as one

    11 Alachua Would show in text box
    09 September


    and the Sql would look some like


    Dplay: [numberfieldname] & " " & [texttobedisplayedfeild]
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Oct 2006
    Posts
    110
    This wouldnt help me, I am trying to always display my text from the combo box list, but want to enter it was a number, and have the corresponding text show up in the field.

  5. #5
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    column widths 0; 2cm
    column count 2
    bound column 1
    rowsource valuelist (could also be a table)
    1; "January", 2, "February", and so on
    (my airport 30 minute WLAN is about to expire - don't have time to lookup if the value list should be , or ; separated: help will help)

    type or select or retrieve a 2
    ...it shows February

    first non-zero-width column is displayed in a non-dropped-down combo.

    izy
    currently using SS 2008R2

Posting Permissions

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