[AccessD] Data-driven option buttons

Personally I like the option button look for a survey/questionnaire so I'm
glad you have a solution, but just for the sake of exploring other options,
would a list box have worked?  It would show all of the options instead of
just one at a time like a combo box.

-----Original Message-----
From: artful at rogers.com [mailto:artful at rogers.com]
Sent: Thursday, August 31, 2006 12:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data-driven option buttons


It turned out to be trivial to populate the labels for the option group. In
addition, the large problem with a combo box is that only one option is
visible at a time. Given that only one question will be visible at a time,
screen real estate is definitely not the issue, so my UI preference opts for
an option group -- you can see all the available choices at once, which I
deem superior in this context (not all contexts, of course, but in this
one). As to simpler, I can't imagine that it gets much simpler than this:

<code>
Private Sub Form_Current()
    With Me
        If Not .NewRecord Then
            .Answers_frame.Visible = True
            .Option5.Visible = Not IsNull(.Answer5)
            .Answer5_lbl.Caption = Nz(.Answer5, "")
             .Option4.Visible = Not IsNull(.Answer4)
            .Answer4_lbl.Caption = Nz(.Answer4, "")
             .Option3.Visible = Not IsNull(.Answer3)
            .Answer3_lbl.Caption = Nz(.Answer3, "")
             .Option2.Visible = Not IsNull(.Answer2)
            .Answer2_lbl.Caption = Nz(.Answer2, "")
             .Option1.Visible = Not IsNull(.Answer1)
            .Answer1_lbl.Caption = Nz(.Answer1, "")
        Else
            .Answers_frame.Visible = False
        End If
    End With
End Sub
</code>


----- Original Message ----
From: Andy Lacey <andy at minstersystems.co.uk>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Sent: Thursday, August 31, 2006 1:03:40 PM
Subject: Re: [AccessD] Data-driven option buttons

My first question, Arthur, would be "can't you use a combo-box"? Be SOOOO
much simpler.

--
Andy Lacey
http://www.minstersystems.co.uk


**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************