Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Thumbs down Unanswered: Number & Text Value in Combo

    I am using a table which has two fields in it. CountyID which is an autonumber and County which is a text value.

    In my forms, the user can pull down a list box to pick the correct value. The text value shows, the user click and the numeric value is stored in the table. That all works fine but...

    when I am using an expression in a report or exporting data to a spreadsheet, it only shows the numeric value for county, is there a way to show the text value instead.

    Last edited by Smilla; 02-18-04 at 12:54.

  2. #2
    Join Date
    Oct 2003
    Provided Answers: 1
    You have to put these values in a table [a keyTable] for example K_Countery with fields like countryID, country_short and country_long
    fill your table

    Make this table as a RowSource of your ListBox or ComboBox, the user chooses a countery and its number will be stored in the table.

    Then in your Report, it should be based on a Query, which includes your Table and the KeyTable i.e k_Country, and choose the long name or the short name.

Posting Permissions

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