>>>There's a form with a general field that's bound to a JPG.
>>>There's a table (SURVEYOR) that holds: char FOTO field - string of full path to JPG (including the name.jpg), and:
>>> general field FOTOGEN - JPG file
>>>
>>>On the form the JPG photo displays OK. When trying to print out a label, that includes the photo, get error "must be bound to a general field"
>>>
>>>The label field's properties are set to FILE - ( SURVEYOR.FOTO) - including the brackets to give a name expr - i.e. the above full path.
>>>
>>>This was working fine and when one opened the gen field one saw the actual pic. But now all one sees is the name of the file, e.g. Brian.jpg.
>>>
>>>It's since moving to XP sp2 from sp1. On X2-clicking a jpg file we found that it's now displayed in "Microsoft photo viewer" or some such (whereas before it was "Windows Picture and Fax Viewer"). So the JPGs have become associated with the new software. When substituting for an older JPG the whole worked fine.
>>>
>>>So we disassociated JPGs from the new and it all works fine again. This is OK for in-house use but, if a customer were to use the software, and have Xp SP2, and view their JPGs with this, it would screw up the system.
>>>
>>>Essentially I'm asking how one would get around this. Is there some way of automating file association, away from this new evil, to ensure it doesn't happen again?
>>>
>>
>>Are you just using a GENERAL field to store a JPEG? If so, why? VFP7 supports JPEGs natively in reports.
>>>'ppreciate it
>
>Hi Al
>
>First of all, it's not my system, but I was called in by a colleague to help sort out someone else's system.
>I appreciate that reports support jpegs but doesn't one have to have a definite file as the source (e.g. for a water-mark or company logo - it would be the same picture on every label)? This requires different photos of agents. Hence I assumed that is why a table field is required. Besides, without delving too deeply into how the system works, I've only got the error message "must be bound to a general field" to go on. Further, nothing's change except the OS, and it was working fine before.
>
>Terry

Just store a file reference to the jpgs in a character field of your source table. Add the picture control to the report, select File on the control and enter the field name of the file reference in ().

HTH,