Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    option groups as text in reports (2000)

    I have a number of fields which use numbers for options - so I can use options groups for data entry. how can I make my report and/or queries show text entries instead = eg 1,2,3 translates as Expert, Intermediate, Novice for different course levels.

    I can format boolean fields with no problem - but ;"smoker";"nonsmoker" doesn't seem to work for option groups!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: option groups as text in reports (2000)

    Create lookup tables with the text entries, e.g.

    <table border=1><td>ID</td><td>Description</td><td>1</td><td>Expert</td><td>2</td><td>Intermediate</td><td>3</td><td>Novice</td></table>

    In the design view of the main data table, select the relevant field and click the Lookup tab. Set:
    display control = combo box
    row source type = table/query
    row source = name of lookup table
    number of columns = 2
    column widths = 0";1"

    From now on, if you drag this field from the field list into a query grid or onto a report, it will be a combo box displaying the description.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: option groups as text in reports (2000)

    Due to the ability of the users I need it to be via buttons - that is why I have gone for option groups which mean I can use really big buttons - picking from a list or selecting a combo drop down is not going to be practical in this application. therefore I need a way of formating queries and reports so that they show the text equivalents.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: option groups as text in reports (2000)

    In your query, use the following expression where field1 = the field containing your numbers :
    <pre>Level: Choose([Field1],"Expert","Itermediate","Novice")</pre>

    Francois

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: option groups as text in reports (2000)

    Even if you have a combo box in queries and reports to display the descriptions, you can still use an option group for easier data entry in forms.

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: option groups as text in reports (2000)

    Thanks to both of you - I am using Choose in the short term - but am going to convert all my relevant fields to look up combo boxes as time permits!!!

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: option groups as text in reports (2000)

    Combo boxes are the way to go for fast data entry, especially if there is a single letter that can determine the selection. In this way you don't even have to use the mouse, all you need do is type the first letter then the enter key.
    My 2 cents worth.
    Pat

Posting Permissions

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