Help report load event

[31si]

I really need some help, i am a visual basic programmer and have no real iddea how to use Access.

I have a report that populates from a query, what i would like to be able to do is when the report is made is to do like conditioal formatting on it. There is a field from the query called "rank" which is a represented as a combo box, what i would like to be able to do is check the value of this rank field and change a picture box accordingly. I know this can be done in visual basic i jsut don't know what event to put the script under. I have already written the script and tested it, it is just the event that i am stuck on.

Any ideas?

 

[Rich]

Usually the Detail OnFormat event

 

[31si]

Thanks

You got the right event which is great i have got it working sort of.

The problem is now, i am using the CASE command to check the value of "rank.listindex" and then on each case branch i set the picture that is displayed in the picure box. The problem i have now is that when i change the picture box it change all of the picture boxes from the other records that have already been loaded.

Again any idea's?