Hi, ok thanks, looks much better now...


>In my SELECT statment I do something like:

>
>	select s.styleNum, s.description, ;
>		...more fields ...,;
>		fullPictureFileName(s.picfile) as picFile, ;
>                ...more stuff

>FullPictureFileName() prepends the full path (stored in application object) to the file name, and does trimming. Also, it makes sure that the file exists. If the field is blank, or if the file does not exist, fullPictureFileName returns oApp.noPictureFileName. In my application object, this is the full file name of a blank JPG file (or it could be a JPG file that has "NO PICTURE" on it).