need a if stament on a report

[prostheticHead]

i need to have like a if statment on a report.

If adjusters code = "NA"
then dont display adjuster details and display insurer details..
else
dont display insurer details and display adjuster details.

but i keep geting the message that the text area needs focus. but i cant set focus on a report

so anyone have any ideas of how i can get around this problem?

 

[maxmangion]

where did you try to put that code ?

 

[prostheticHead]

in the report Open event

 

[Rich]

Use one of the OnFormat events

 

[prostheticHead]

the if statment now works! thanks heaps. But i cant make the text box invisible

im just using me.txtAdjustersName.Visible = False

this dosnt work. any ideas of what would work?

EDIT::: looks like Me.txtAdjustersName.Application.Visible = False works

EDIT X2 :: OK NO IT DOSNT! it just errors out..

EDIT X3 :: ok now it just felt like working i must have had soemthing messed up dont know what but now me.txtAdjustersName.Visible = False is working fine!

Thanks every one for ya help!