Change Checkbox appearance

[Rubi]

Hello everyone,
I have a form containing customer details. one of the controlers is a checkbox which source is a yes/no field in the my 'customers' table.
I'm trying to invert the checkbox so it would show TRUE when the value is False and vice versa. (and change the values in the table with the original TRUE/FALSE.

can anyone please help ??

 

[IMO]

Create another column in your table and call it 'Value' then put this code in the OnClick event of your CheckBox

Private Sub YourCheckBox_Click()
If Me.YourCheckBox = True Then
Me.Value = "False"
Else
Me.Value = "True"
End If
End Sub

IMO

 

[WayneRyan]

Rubi,

One way of accomplishing this is to make your checkbox invisible.

Make a new unbound textbox - txtCheck.

Its default value can be "True" or "False".

In the OnCurrent event for your record:

If Me.MyCheckBox = True Then
   Me.txtCheck = "True"
Else
   Me.txtCheck = "False"
End If

In the AfterUpdate of txtCheck:

If Me.txtCheck = "True" Then
   Me.MyCheckBox = True
Else
   Me.MyCheckBox = False
End If

Just some rough ideas ...
Wayne

IMO's response made me reread your post. I was thinking that
we were trying to do something entirely different.

Never mind ...

 

[Rubi]

Thanks WayneRyan,
I have some questions though...
1)what is : "OnCurrent Event for your record", what record do you mean ? and where can I insert the code ?

2) can this solution work on a "Tabular" form ?

 

[IMO]

 

[Rubi]

Sorry IMO

I appreciate your help vary much,
I've tried your suggestion and it didn't do exactly what I wanted.
I need the controler to change the original checkbox field.

thanks,

 

[Rubi]

IMO,

Could you explain your solution please, I think I misunderstood it.
it may be the right way to do this after all.

 

[IMO]

If you create the Column 'Value' in your table, if the CheckBox is clicked (True) the 'Value' field would show False

IMO