Images on report offset to previous 'detail'

[widemonk]

Hi folks,
I have a report that lists peoples names and login IDs and there is also a mugshot of that person.
(As well as other detail, but thats not important).

• The image file name is the same as the login ID.
• The rest of the file path is in a non-visible control called txtPath... ="filepath" & [LoginID]
• The image source is linked, determined in the Detail_Format part of code...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error Resume Next
  imgMugshot.Picture = "" 'to set the image blank, in case of error
  imgMugshot.Picture = txtPath
End Sub

All works fine until, the problem...
The mugshots arent displayed adjacent to the person they're supposed to be, like so...

NameOfPerson1 MugshotOfLastPerson
NameOfPerson2 MugshotOfPerson1
NameOfPerson3 MugshotOfPerson2
NameOfPerson4 MugshotOfPerson3

I know Access Reports kind of view the details twice, for instance you cant have a Sum / Total at the bottom of a financial report without first listing the whole thing and knowing where the actual bottom is... or similar.

I suspect this is a variation on that theme but dont know how to correct it.

I am using Access Pro Plus 2013

 

[spikepl]

Computers tend to be bitchy and do what they are told, which is not necessarily what is desired. Proof of the pudding would be a

debug.print loginID, txtPath ' in your Detail_Format thinggy