Change number to text in report

[sour]

I have a report that has week numbers within each week are cranes that have a delivery date, I have identified that all cranes go into storage has a week "0"
Within the report I want to replace the "0" with some text "STORE", I have tried VBA using an if statement, conditioning format just cant get it to work, the "0" is a number field, any ideas.

 

[June7]

Can have expression in query or textbox ControlSource.

=IIf([fieldname]=0, "STORE", [fieldname])

 

[sour]

Ok I have just tried it but get a syntax error, I have tried it by adding the result to a text box as below

Private Sub Report_Open(Cancel As Integer)
=IIf([WK]=0, "STORE", [TEXT168])
End If
End Sub

 

[sour]

Sorry forgot to put thanks for your help

 

[sour]

O just tried it in the query worked first time thank you very much.

 

[June7]

The VBA you attempted is invalid structure, totally nonsense. VBA would not be best approach anyway.

Glad you got it resolved.