Code behind AutoFormats - Access 2007

H

h2fcell

Is there a way to see the code related to the AutoFormats supplied in Access
2007 ?
I'd like to see how graphic backgrounds are achieved for Form Header, like
the one used in Solstice AutoFormat.

Thanks.
 
A

Albert D. Kallal

h2fcell said:
Is there a way to see the code related to the AutoFormats supplied in
Access
2007 ?
I'd like to see how graphic backgrounds are achieved for Form Header, like
the one used in Solstice AutoFormat.

The graphic is just a simple bit map. If you want to grab those bit maps
just delete any text box and icon in the forms header. Then while in view
mode simply hit screen-print. Now, fire up your favorite paint program and
simply paste in the screen shot. Just cut out the forms heading....

At that point you can save this as a jpeg or bmp. Take a look at the
existing form in design mode, note the settings for the background image
(stretched for example).

there nothing more to this effect the above....

I not sure if/where the bmp's are stored on disk..but, you can "lift" them
out as per above....
 
H

h2fcell

Hi Albert,
Your answer is not what I'm looking for. I've read posts that suggest code
behind those fancy AutoFormats. For one, the color used in some are Gradient
fill.
Where's the property setting for Gradient fill?
 
H

h2fcell

Hello Albert,
Your answer is not what I was looking for. I've read in some posts that
there is code enabling those fancy AutoFormats. Some have Gradient color
fill.
Where is the property setting to get a Gradient color fill in a forms header?
 
A

Albert D. Kallal

h2fcell said:
Hi Albert,
Your answer is not what I'm looking for. I've read posts that suggest
code
behind those fancy AutoFormats. For one, the color used in some are
Gradient
fill.
Where's the property setting for Gradient fill?

There is no property for gradient fill, that is simply the graphic image
they used for the top of the form.

So, these are just regular forms property settings, and access has worked
much like this for seventeen years and there is no code here.

However, do keep in mind access 2007 is a really nice step up in terms of
graphics features and settings that are new.

For example if you resize that form, you'll notice how the graphic at the
top of the screen stretches and shrinks along with the form. This is
something
you can't do in previous versions of access. In this case this effect is
achieved by the stretch horizontal setting you have in the property sheets
for the background image.

So, there is quite a few improvements in 07 such as transparent buttons
(they take the color from behind the form - this is really nice).
Another nice feature is now buttons allow graphics + text (again as the
feature I've wanted for years).

And our new image control allows us to bind the image control to a field
that specifies the path name. At the end of the day this means that we can
have a continuous form display different graphic elements, and again this is
an wonderful addition to access. This means we can build continuous forms
that look like a "listview" contorl in VB6. For example I can have a
continuous form that displays a bunch of people their names and their
country. Beside the country I could display their country flag as an graphic
image. We could not do this prior to 2007 without resorting to using ActiveX
controls (third party solutions).

Once again I will go through the procedure of how I can "lift" out that
graphic from that form:

Bbring up that form in design mode (actually make a copy of the original
form
you're working on, 'cause we're likely to messes up a bit).

now, simply delete the icon and text box from the forms heading.

Now bring up the property sheets for this form, on the format tab, Change
the setting of the background sizing

Picture size mode: Stretch horizontial ---> change this to "clip"

The reason why I changed to clip mode, is we're going to lift out this
graphic and we don't want any distortion and one to keep the nice gradient
still in place. In other words are going to lift this graphic out in its
native original size to format.

Now flip the form into view mode, (and I assume that you're also NOT using a
tabbed interface here...right???).

At this point size the form to the right larger and larger until the graphic
is not being cut off anymore at all. in fact size a bit larger.

At this point you can hit the print screen button, and then paste your
screen capture into your favorite paint program. Now cut out the area of the
top of the form where the graphic is.

Note that this cut is quite easy because you can miss a little bit on all
the the edges as they really don't matter.

Here's an actual screen shot and graphic cutout of the soltisce bmp pulled
out for you. In fact while looking at the following web page link you can
right click on that graphic and save it to your hard disk.

http://www.kallal.ca/test/accessv1.html

By the way the above link is just a test junk webpage I have for throwing up
all kinds of garbage. So scroll down to the very end of the above web page
and you'll find the Bmp I speak about...

So there's no question that we have a lot of great graphical features in
access 2007, but the end of the day these features are done without any
coding, and these effects are simlly settings of the form..
 
H

h2fcell

Hello Albert,
First of all I'd like to thank you for your responses. I don't think I've
described what I wanted to accomplish clearly enough. You seem to think I
want to copy “lift†the AutoFormats graphics. I think I know now what was
confusing me. When I choose an AutoFormat say “Windows Vistaâ€, the Picture
property changes from (none) to (image) with Picture Size Mode set to Stretch
Horizontal. I’ve used this Picture property before but my images always had
a name. I was hoping when I choose an AutoFormat the name of the picture or
format would appear in the Picture property instead of just (image) so I
would know by looking at the Picture property I was using “Windows Vistaâ€.
Maybe the next version of Access will fix this and have a Fill Effects menu
like in Word 2007, for Forms backgrounds so we don’t have to create all
effects outside of Access.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top