Simple Checkbox Question

Ask a Question related to Microsoft Access, Design and Development.

  1. #1

    Default Simple Checkbox Question

    Hello,

    I have a checkbox on a form (i know very little about
    checkboxes) and I wanted it to be unchecked, so i set
    triple state to yes. Although id perfer only 2
    states "checked/unchecked" because I dont really know
    what the third state does. With that, how do i identify
    what state the checkbox is in (used for if structure etc)
    Thanks

    Mary
    Mary Guest

  2. Similar Questions and Discussions

    1. Need Simple Answer to Simple Contribute/Firefox question
      Hello all; I've tried the Adobe help in CS3, tech support, phone support, this forum, other forums, Mozilla, and nowhere can I get a straight...
    2. Howto bind CheckBox to the datagrid/ Then update the database field when the checkbox is clicked.
      I am trying to update the database field when the checkbox is clicked. I am trying to modified the following solution but.. got stuck on the...
    3. am i missing something simple asp:checkbox
      Hi I have a table in my db which basically stores users preferences as either a 1 or 0 (sql server tinyInt) I built the insert page using MM...
    4. Simple checkbox population from Access
      I am trying to populate a list of between 5-10 items which will be drawn from an Access Table to a form wherein the visitor can check boxes of each...
    5. Form CheckBox question
      Hello, I have this in my form.... the checkUnCheck(this); will uncheck values 1,2,3 if None is chosen... Now when I submit this form, the output...
  3. #2

    Default Simple Checkbox Question

    Hey Mary

    The easiest way to actually to get what you seem to want
    is by using an Option Group. If you use the Wizard when
    creating it, it'll ask you what you want to label each
    check box, whether or not you want a default (one option
    chosen when the form is opened), what value to set each
    check box to, and then what you want it to look like.

    What this does is that one and only one option can be
    chosen at any given time. So, if you did one label "Yes",
    and the other "No", each would be assigned a numeric value
    (let's say, Yes = 1 and No = 2) so that if Yes is chosen,
    the OptionGroupValue = 1, and if No is chosen, the
    OptionGroupValue = 2.

    Hope this helps!

    Sullivan
    >-----Original Message-----
    >Hello,
    >
    >I have a checkbox on a form (i know very little about
    >checkboxes) and I wanted it to be unchecked, so i set
    >triple state to yes. Although id perfer only 2
    >states "checked/unchecked" because I dont really know
    >what the third state does. With that, how do i identify
    >what state the checkbox is in (used for if structure etc)
    >Thanks
    >
    >Mary
    >.
    >
    Sullivan Guest

  4. #3

    Default Simple Checkbox Question

    Sull,

    I know the basics of checkboxes, but in this case, i ONLY
    want 1 checkbox, checked/unchecked. and id like to know
    the property to see if the checkbox is checked (even if
    its in an option group) ie:

    if checkbox.checked = true then.....

    if checkbox.checked = false then..

    ya know?

    Mary
    >-----Original Message-----
    >Hey Mary
    >
    >The easiest way to actually to get what you seem to want
    >is by using an Option Group. If you use the Wizard when
    >creating it, it'll ask you what you want to label each
    >check box, whether or not you want a default (one option
    >chosen when the form is opened), what value to set each
    >check box to, and then what you want it to look like.
    >
    >What this does is that one and only one option can be
    >chosen at any given time. So, if you did one
    label "Yes",
    >and the other "No", each would be assigned a numeric
    value
    >(let's say, Yes = 1 and No = 2) so that if Yes is
    chosen,
    >the OptionGroupValue = 1, and if No is chosen, the
    >OptionGroupValue = 2.
    >
    >Hope this helps!
    >
    >Sullivan
    >>-----Original Message-----
    >>Hello,
    >>
    >>I have a checkbox on a form (i know very little about
    >>checkboxes) and I wanted it to be unchecked, so i set
    >>triple state to yes. Although id perfer only 2
    >>states "checked/unchecked" because I dont really know
    >>what the third state does. With that, how do i identify
    >>what state the checkbox is in (used for if structure
    etc)
    >>Thanks
    >>
    >>Mary
    >>.
    >>
    >.
    >
    Mary Guest

  5. #4

    Default Re: Simple Checkbox Question

    Mary,
    I assume this check box is unbound.
    It seems to me that if you want the form to open with
    the Checkbox unchecked, just set the check box
    default property to 0 (or False, or No, or Off),
    and Triple State No.

    Then you can read it in an event on the form
    to determine if it's been changed to -1 (or True, or Yes, or Off):

    If [Checkfield] = 0 Then
    ' it's unchecked
    Else
    ' It's checked
    End If
    --
    Fred

    Please reply only to this newsgroup.
    I do not reply to personal e-mail.


    "Mary" <Marygb@hotmail.com> wrote in message
    news:013901c35066$ef638970$a101280a@phx.gbl...
    > Hello,
    >
    > I have a checkbox on a form (i know very little about
    > checkboxes) and I wanted it to be unchecked, so i set
    > triple state to yes. Although id perfer only 2
    > states "checked/unchecked" because I dont really know
    > what the third state does. With that, how do i identify
    > what state the checkbox is in (used for if structure etc)
    > Thanks
    >
    > Mary

    Fredg Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139