Backstyle in 2003 but not in 2007?

[Hugh self taught]

Hi,

The forms I designed in Access 2003 that I've imported into my access 2007
maintain their background style & their properties shows "Picture" as
(bitmap) whereas the other 2007 designed forms show (none) & only allow you
to select a graphic. Any idea how to get that same backstyle in my 2007 forms?

 

[Albert D. Kallal]

Hi,

The forms I designed in Access 2003 that I've imported into my access 2007
maintain their background style & their properties shows "Picture" as
(bitmap) whereas the other 2007 designed forms show (none) & only allow
you
to select a graphic. Any idea how to get that same backstyle in my 2007
forms?

I not really aware of any change in this regards.

open the form in design mode:

And then display the properties sheet. You can select a picture for the
background. Is that what the 2003 forms have?


You can always pick a particular form, and use that as a template in 2007 (a
very nice feature access 2007 which means access will remember your fonts,
colors, control layout when you add new controls. In fact just about
everything
for a form will be inherited when you create a new form.
You could use this "nice" "template" feature until you figure out what
formatting
or picture property is different here.

To "set" an existing form as a default template go:

office button->access options->Object Designers->

scroll down until you get to Form Template.
You can now "select" one of those older forms for a "default" look + feel...

 

[Tom van Stiphout]

On Sat, 21 Mar 2009 03:45:01 -0700, Hugh self taught

Check out the Picture property at the Form level.

-Tom.
Microsoft Access MVP

 

[Hugh self taught]

Thanks for that advise. I've done that & tested it. Works great. However that
is fine for future forms created in "Design View" Creating a form using the
wizard doesn't give the same textured background options that Access 2003
did. I happen to like the textures that I used from there but now have some
forms without it & some with it in the same database. I would like them to be
consistant with the textured background. (Not so boring to look at)

As per my original post, the forms without the texture have (none) as the
"picture" property while the forms with the texture have (bitmap). When
selecting the "picture" property to try change it, the only option is to
choose a graphic from disc. How do I get the textured graphic as a background
/ backstyle?

 

[Hugh self taught]

As per my original post, the forms without the texture have (none) as the
"picture" property while the forms with the texture have (bitmap). When
selecting the "picture" property to try change it, the only option is to
choose a graphic from disc. How do I get the textured graphic as a
background / backstyle? In both the instances the picture type is "embedded"

 

[Jeff Conrad [MSFT]]

Hi Hugh,

See if these steps help:

1. Right-click on the form in the Navigation Pane that has the 2003 background you want and select
Export >> XML
2. On the first page of the wizard, select a destination to drop some files (Desktop is fine for
now)
3. A small dialog will then appear with three check boxes
4. Select the first option (Data) and third option (Presentation) and then click OK
5. Click the Close button on the last page of the wizard after the export is complete
6. Navigate to where you dropped the files and among other things you'll find a new folder called
Images
7. Open that folder and you should find the background image/graphic you've been using in 2003
8. You should then be able to browse to that background image to use for your new 2007 forms Picture
property

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Albert D. Kallal]

Thanks for that advise. I've done that & tested it. Works great. However
that
is fine for future forms created in "Design View" Creating a form using
the
wizard doesn't give the same textured background options that Access 2003
did. I happen to like the textures that I used from there but now have
some
forms without it & some with it in the same database. I would like them to
be
consistant with the textured background. (Not so boring to look at)

As per my original post, the forms without the texture have (none) as the
"picture" property while the forms with the texture have (bitmap). When
selecting the "picture" property to try change it, the only option is to
choose a graphic from disc. How do I get the textured graphic as a
background
/ backstyle?

if you "set" an older style form as a template, does not the wizard use that
textured background?????

For the existing ones, you have to grab that bitmap from the older
machine....

Remember, you *can* imbed the bit map when you select it, or not. If you
choose NOT to, then that bitmap MUST be located on the machine when you copy
the database. so, embedding as you have has some benefits.

However, those bitmaps cause SEROUS BLOAT in the size of the database. I
have an application with 160 forms, and 30,000 lines of code. The whole
application as a mde is only 7 mb in size. With pictures...it was about 70
megs. So, those pictures really bloat up the database size. this is supposed
to be better in 2007 but you want to keep your application smaller and
light....try to avoid those bitmaps.

the bitmap location for access 2003 is :

C:\Program Files\Microsoft Office\OFFICE11\BITMAPS\STYLES\ACSNDSTN.GIF

You should when you "click" on the browse for background picture in 2007 be
able to browse to

C:\Program Files\Microsoft Office\Office12\BITMAPS\STYLES\ACSNDSTN.GIF

The example above is the "sand stone" background, you should be able to find
the others in that directory that you using now....