Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Atlanta, Georgia, USA
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Boolean values on bound form (Access 2000 SR1)

    OK - here's another one that's probably an obvious slam-dunk, but I can't figure it out, so it's time to go to the experts.

    Same form I've been working on for the past two weeks. It is bound to a table that has several boolean values. I'd like to put Option buttions on the form so that the user can select only one of the values. How do I tell Access that the field is the True or False portion of a boolean field?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Boolean values on bound form (Access 2000 SR1)

    Use a checkbox and bind it to the Yes/No field, assuming you're talking about an Access table behind it. I don't understand what you mean by a "True or False portion of a boolean field". Yes/No fields have a value of True, False or Null..
    Charlotte

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

    Re: Boolean values on bound form (Access 2000 SR1)

    To do this, you shouldn't put "loose" option buttons on the form, but in an option group. You bind the option group as a whole to a boolean field.

    The easiest way to do this is to use the Control Wizard.
    <UL><LI>Open the form in design view.
    <LI>If necessary, make the Control Toolset visible.
    <LI>Make sure that Control Wizards are active (the "Magic Wand" button on the Toolset must be "on")
    <LI>Click the Group Box button on the Toolset, then click in the form, or drag a rectangle.
    <LI>The Group Box Wizard starts. In the first step, enter two labels, for instance Yes and No, or True and False. Then click Next.
    <LI>Select a default option, or specify that you don't want one. Click Next.
    <LI>Assign the value -1 to the Yes/True option, and 0 to the No/False option. Click Next.
    <LI>Select the field that you want this group box to be bound to. Click Next.
    <LI>Select formatting options - the default settings are usually OK. Click Next.
    <LI>Specify tha caption. Click Finish.[/list]Takes longer to write down than to actually do it!

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Location
    Atlanta, Georgia, USA
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Boolean values on bound form (Access 2000 SR1)

    Hans:
    I wasn't actually trying to make them 'loose' option buttons. I had tried the Control Wizard, but I missed the part about using -1 and 0, so I could never make it work. That was perfect! Thank you!

Posting Permissions

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