Using Background Images in a Form

  • Thread starter Thread starter BruDe
  • Start date Start date
B

BruDe

I develeoped a database for a friend to track inventory and
monitor consumables. She asked me to add a company
logao to the Switchboard and the same background used on
the company web page. The original background was a
bitmap that was over 1MB in size. By changing it to a
JPEG, I reduced the footprint to 26 Kb. But, when I add it to
the forms as a background picture (there are 15 forms that
use the background), the database swelled from 5 Mb, to
over 80Mb (after runing compact and repair). What can I do
to reduce the size without eliminating the background image?
 
If you must embedd the Image directly in each Form then there is no
solution that will reduce size of the MDB significantly. Inserting the
original BMP file will yield the best results.
I must also state that you may run into some severe problems using an
Image in the Background of your forms. If you must then do not
tile/scale the Image. I personally would reccommend against it.

A couple of options.
1) Embedd the Image in a single form. Ensure this form is always open
even if you have to keep it invisible.
In the Load event of each of the rest of your forms do something like:
Me.PictureData = Forms!TheNameOfTheMasterFormWithLogo.PictureData

2) Store the Logo in the same folder as the application MDB and then
load the Logo in the Form's Load event:
Me.Picture = /path/filename


--

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