Can't use IF command to change text in a box?! 1

[Stevehewitt]

Hey,

Sorry about the title - not too descriptive.

I have a report, where each record has a Yes/No field. Default is No. (Its a 'Finished Job' field with a tick box)

On the report, I don't want it to show a tick box, I need it to show a Yes or a No.
I tried the following but i'm getting nothing:

Private Sub Report_Activate()
If Me.Done.Value = "0" Then
Me.DoneView.Value = No
Else
Me.DoneView.Value = Yes
Else
End If
End Sub

Anyone tell me where I am going wrong?

Thanks,


Steve.

 

[ghalewood]

I think you need to put the following in the control source of a text box call doneview

=IIf([done]=0,"No","Yes")

 

[Stevehewitt]

Hey,

Thanks. That worked a treat!!!

Thanks again,


Steve.