Option Group Table Data Type

[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?

 

[pietlinden]

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?

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.

 

[Coffee Gal]

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.

 

[John W. Vinson/MVP]

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.

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

 

[pietlinden]

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.

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

Wow, that's a carcinogenic joke.