Check box value

[balistikb]

I have inserted a check box in my form. The forms infomation gets inputed into a SQL table that is linked to this database. When the user checks the check box it puts a value of -1 in the SQL database. How can I get it to put in yes or no or inactive or active. The reason being is that my report is outputing -1 or 0 and that I do not want.
I tried changing it in the table level of access but because it isn't an access table it doesn't allow me to change/

 

[Chalco]

on the report add an unbound item (fred), create an event for the "on Format" event

(assuming that you database field is called john, for want of a better name)

Within this program you can do the following

if me.john = true then
me.fred="Checked"
else
me.fred="Not Checked"
end if

 

[TelcoBT]

The simplest thing to do is actually take the -1 or 0 field in the report and amend it there,

Either have textBox with

=IIF(myField,'Yes','No')

as the source - where myField is your field name, OR
maybe include a combo box bound to this field with a value list where -1 is related to yes and 0 to no.

 

[balistikb]

I would like to do it on the report end but I am not sure where or how.