I created a report for an Access database. In one of the fields there is a complete path to an image. When previewing or printing the report, it always does not print the first records image. Everything after that is fine. The first records image does exist, just like the others. Any idea why this is and more importantly, how to fix it?

Don

'If you want to get a brontosaurus from 'a' to 'b' then you ride the dinosaur - you don't carry it!'

Well we should probably delete this post before I confuse everyone else.

Here's the deal. For some reason, when my mdb loads, it puts my records in an odd order. It does not start at record 1 (as is in the mdb) but starts at record 13. Record 13 as it turns out does not have a path in it to the image so that explains that part of it. I can push the sort column header and it puts the records in correct order. I've looked at the data in the column for some abnormality that would cause the odd sort but don't see any.

I would have thought it would load the records in the original order if there was no sort action and I do not have one.

Now the other odd part is that this is not the first time I have seen this. I have loaded other databases (similar) and they always seem to show the blank first record image (but now I think it was that for some reason my program is not putting a path in record 13 (oh there it is record 13, ooooohhhh) and then showing it as the first record. This is getting too goofy to even write out.

How about just deleting this post until I can figure out what I've got going on.

Don

'If you want to get a brontosaurus from 'a' to 'b' then you ride the dinosaur - you don't carry it!'

I'm not sure why the database would open with records in an odd order unless you have some type of sort applied. However, if you've deleted and added records over time, they may not appear in file in the order you expect.