Option Group Table Data Type

  • Thread starter Thread starter Coffee Gal
  • Start date Start date
C

Coffee Gal

I have a table field with yes/no data type. Can I use this in an option
group or does the type need to be number? I originally set up a yes/no field
that the user is supposed to check if the project contains asbestos. Now I
need to produce a new report that has a check box for yes and one for no. I
have tried to bind an option group to my data but I think I need to change
the data type. Can someone explain to me how option groups / table data
types relate?
 
I have a table field with yes/no data type.  Can I use this in an option
group or does the type need to be number?  I originally set up a yes/nofield
that the user is supposed to check if the project contains asbestos.  Now I
need to produce a new report that has a check box for yes and one for no. I
have tried to bind an option group to my data but I think I need to change
the data type.  Can someone explain to me how option groups / table data
types relate?
Click to expand...

why use an option group? just use a Yes/No field. It should do
checkboxes for you. If you have to convert it, use an update query.
 
That's what I currently have but I only have one check box. How do I bind 2
check boxes to one field that will have one checked for yes or one checked
for no.

I'm sure I am over thinking this. It's always the simple things that kick
my butt. The complex stuff I have not problem with....go figure.
 
Coffee Gal said:
That's what I currently have but I only have one check box. How do I bind
2
check boxes to one field that will have one checked for yes or one checked
for no.
Click to expand...

Use [Contains Asbestos] (or whatever the actual fieldname is) as the Control
Source for the "yes" box, and

=Not [Contains Asbestos]

as the control source for the No checkbox.

We do Asbestos we can...
 
That's what I currently have but I only have one check box.  How do Ibind
2
check boxes to one field that will have one checked for yes or one checked
for no.
Click to expand...

Use [Contains Asbestos] (or whatever the actual fieldname is) as the Control
Source for the "yes" box, and

=Not [Contains Asbestos]

as the control source for the No checkbox.

We do Asbestos we can...
Click to expand...

Wow, that's a carcinogenic joke.
 
Back
Top