Boolean values on bound form (Access 2000 SR1)

Topic

New Reply

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?

Reply | Quote

Replies

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..

Reply | Quote

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.

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

Reply | Quote

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!

Reply | Quote