Image too large

[Jason]

How can I check the size (kb) of a jpg file before I link it to the OLE
object? So I can have a message pop up before attempting to link.

Thanks,
J.

 

[Stuart McCall]

How can I check the size (kb) of a jpg file before I link it to the OLE
object? So I can have a message pop up before attempting to link.

Thanks,
J.

SizeOfJpg = FileLen("c:\temp\MyJpg.jpg")

 

[Jason]

Thanks,
Didn't know it was that simple. Forgot to ask what is the size limit for
photoeditor in access? (From access code it is saying the file is too large
for photoedito)

 

[Jason]

For some reason the file that is failing is 1207kb and a file of 3284kb
works in Access. What I have done is use Corel to resample to 80,90 and 99%
of original file size - all fail in MS Photo editor except for the 80%
reduced one. All the resampled ones (80, 90 and 99%) embed OK in access even
though their file sizes are now larger. There must be something else that is
failing the 1.207 Mb file even though it has the highest pixels (3576 x
3420, 1207kb) compared to the 99% (3218 x 3386, 3284kb) one.