Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

Storing an image in an RTF Control

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
genojoe - 25 Oct 2005 01:15 GMT
I have a form with an RTF control.  It can contain one or more images along
with text. The result is stored in a memo field in a table.  As a record, the
field occupies about 200K.  If I save the contents as an RTF file, the size
reduces to about 100K.  If I save the file a jpg, the size reduces to about
30K.  Is there a way to reduce the size of the storage footprint in the
Access table?  

I don't need great resolution.  I am capturing images from the screen and
expect the images to be displayed in the Access form that is sufficiently
readable.
Stephen Lebans - 26 Oct 2005 00:52 GMT
If I remember correctly, the JPG is inserted an OLE Image. This results in,
at the very least, a copy of the image being stored as an UNCOMPRESSED
Bitmap(actually, a DIB wrapped within a Metafile) and a Preview image, again
an uncompressed bitmap. Basically double the fun for your money.

When saved to an RTF disk file, the preview is removed from the file prior
to writing to disk..

The only solution would be for you to modify the resolution(and perhaps
color depth) of the original image. I would work strictly with Bitmaps and
avoid Jpeg.
Signature


HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

>I have a form with an RTF control.  It can contain one or more images along
> with text. The result is stored in a memo field in a table.  As a record,
[quoted text clipped - 9 lines]
> expect the images to be displayed in the Access form that is sufficiently
> readable.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.