PLEASE HELP ME!!

message from trese on 20 May 2004

Question about multiple check boxes in a Form or Report.

I am having a major issue with trying to create multiple
check boxes in a form, table, or report.
1. In the table view, I do not know which "data type" to
use in order to format my field in the form view.
2. I can get multi check boxes, but they only allow me to
choose from only ONE of the choices, while I want to be
able to choose as many or as little options as I choose.
3. If I try to build check boxes manually from the tool
box, it will not show up on report at all under the field
name that I have chosen.

If you know how to do this,...PLEASE HELP...I will be
forever grateful. My boss wants this whole database done
by Monday, and I can not get passed this section. Thanks
and I will be forever greatful!!

John Vinson replied to trese on 20 May 2004

A Yes/No field in a table can be displayed using a checkbox control on
a Form (or a textbox with 0/-1 values, or a combo box, or a listbox...
take your pick).

As suggested, it sounds like you are putting checkboxes in an Option
Group control. Don't. Just have checkboxes built using the Checkbox
tool.

Reports are not based on Forms. Reports are based on Tables. Are you
trying to store *multiple* checkboxes in *one* field? If so it won't
work! Could you explain the structure of your table!?

Good luck...

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Kevin3NF replied to trese on 20 May 2004

1. Choose Yes/No
2. You are probably usin Option group. Don't, unless you only want to allow
I have a sample database if you want it (Access 2000)

Archived message: PLEASE HELP ME!! (MS Access Database)