changing properties for a field

[lamaar]

how do I change the text box properties in VB if the value of a field is a certain number (ie. less than zero, 0 or more than zero? I have used the IIf ([Fieldname], "true", false&quot but this only displays two results. I have a little knowledge of VBA but don't know how to refer to fields within a report. would it be something like

If Report!myfield = 0 Then
Report!Reportname.textbox = "days before"
Else IF ......
Report!....
Esle
Report!...
End If

regards Lamaar75@hotmail.com

 

[Chance1234]

Select Case report!myfield
case 1
Report!Reportname.textbox = "days before"
case 2
Report!Reportname.textbox = "as many"

case 3
Report!Reportname.textbox = "case statements"

case 4

Report!Reportname.textbox = "as you like "

end select