PLEASE HELP ME!!

  • Thread starter Thread starter trese
  • Start date Start date
T

trese

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!!
 
1. Choose Yes/No
2. You are probably usin Option group. Don't, unless you only want to allow
one selection.
3. The report should be based on the table or query, not the form field....

I have a sample database if you want it (Access 2000)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 
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.
Click to expand...

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).
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.
Click to expand...

As suggested, it sounds like you are putting checkboxes in an Option
Group control. Don't. Just have checkboxes built using the Checkbox
tool.
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.
Click to expand...

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!?
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!!
Click to expand...

Good luck...
 
Back
Top