problem with check box

[snoopy22]

hello, i'm newbi to access

i have a check box bound to a yes/no field, my problem is that when i mark/unmark the check box the value of the field is not yes/no,
it is show me a drawing of the state of the check box in the field.
how can i make it to get the value yes/no?

 

[Uncle Gizmo]

If I understand you correctly, Your check box currently shows a tick or a blank and you want to show the words yes or no. Have I got the right end of the stick?

 

[Uncle Gizmo]

Ah! the light dawns, you mean when you view the record in the table or query you have the box drawn with or without a tick and you want yes no in that view. Yes?

 

[snoopy22]

exactly

i want it to show as yes/no on the table field

 

[Uncle Gizmo]

Well I must say I am a little bit puzzled. I added a boolean field to a table and selected the various display options of yes/no true/false on/off but what ever option I selected it always displayed as the check box graphic. I even based a query on the table and a form on the table.

Is this normal? Am I missing something?

 

[Rich]

Since you shouldn't be entering/viewing data directly in a table, then how the boolean field is displayed in the table is irrelevant

 

[snoopy22]

so how can i check the value of the check box?

suppose i have an unbound checkbox name "c_problem1"
and i want to check if it's value is the same as the field in the table
name "problem1"

I know it's vba, but do you know how to do it?

 

[Uncle Gizmo]

Since you shouldn't be entering/viewing data directly in a table, then how the boolean field is displayed in the table is irrelevant

I think you have missed the point Rich, in the table design view you have the option of selecting one of three formats. I would suspect that these formats should propagate down through any queries or forms you subsequently generate from the based table. But that's not happening, so what is the purpose of the three selections?

 

[Uncle Gizmo]

Is this normal? Am I missing something?

Opp's, I am! Right, !n the table design view, in the field listing with your boolean value click on the lookup tab And select "display control" this will then dictate the type of control, in other words you can get rid of the check box and have a text field.

From the general tab you can select how you want the data displayed whether it's Yes/No True/False etc...

Sorry I didn't spot that before, it's a long time since I have used anything other than a checkbox!

 

[Uncle Gizmo]

suppose i have an unbound checkbox name "c_problem1"
and i want to check if it's value is the same as the field in the table
name "problem1"

I know it's vba, but do you know how to do it?

I don't think you could do it this way, you would have to have it bound to the table because there would be no relationship between the check box and the table if it were unbound, so whether it was checked or unchecked would mean nothing to the table, do you see what I mean?

 

[snoopy22]

never mind

i've got it working now... but thanks for the tip about viewing the checkbox as a text field!

 

[Bluie]

can u post how u did it? thanks