Bitmap (blank, or variable size)

[Guest]

I would like to display graphic files as part of my category headers on a
report. The graphic files vary in height although they all take up the same
width.

I would like the report to print the image and then the header with no
wasted space regardless of the size of the image.

I do not want any blank spots for categories where I have not assigned a
graphic.

Please advise.

 

[Terry]

Beverly,


You may have to store the height of the drawing image with
your category data. You could then set the image controls
height with the category header section's "on format"
event. Remember that you need set the height in twips
(1440 twips per inch).

Probably not the solution you were hoping for. You could
check out www.lebans.com - Stephen has some pretty good
stuff on images.

HTH,

Terry

 

[Guest]

Terry,

Thanks for the suggestion. Actually, that sounds like it would work great.
I just want to see if I understand how it works.

In my table where I have my bitmap images, I have a column for bitmap height
in twips. Then, "ON FORMAT" of the category, how do I use that stored info
to set the height?

Thanks again.

 

[Terry]

Beverly

Off the top of head .....


dim picsize as long
picsize = nz(me.[picky height field],0) ' plugs zero if no
height provided
[image control].height = picsize

Substitute your field and image names. If your height
field is in inches use:
picsize = nz(me.[picky height field],0)*1440

I think the section's "on format" event would be a good
place for this.

HTH

Terry

 

[Guest]

Does it make any difference that I'm using a bound ole object frame instead
of an image control?

I may be in over my head here. Is there a book or online source that you
would recommend for visual basic code?

Beverly

Off the top of head .....


dim picsize as long
picsize = nz(me.[picky height field],0) ' plugs zero if no
height provided
[image control].height = picsize

Substitute your field and image names. If your height
field is in inches use:
picsize = nz(me.[picky height field],0)*1440

I think the section's "on format" event would be a good
place for this.

HTH

Terry

-----Original Message-----
Terry,

Thanks for the suggestion. Actually, that sounds like it would work great.
I just want to see if I understand how it works.

In my table where I have my bitmap images, I have a column for bitmap height
in twips. Then, "ON FORMAT" of the category, how do I use that stored info
to set the height?

Thanks again.


.

 

[Stephen Lebans]

With a bound OLE Frame control, simply set the Visible prop of the
control to No when the VALUE prop is NULL.

As for autosizing, it depends on the type of Image you have inserted
into the OLE field.
See:
http://www.lebans.com/autosizeole.htm
A97AutosizeOLE.zip is a database containing functionality to allow for
the auto sizing of bound or unbound OLE Frame controls.

It would be a lot easier to achieve autosizing using the standard Image
control.

--

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

Does it make any difference that I'm using a bound ole object frame instead
of an image control?

I may be in over my head here. Is there a book or online source that you
would recommend for visual basic code?

Beverly

Off the top of head .....


dim picsize as long
picsize = nz(me.[picky height field],0) ' plugs zero if no
height provided
[image control].height = picsize

Substitute your field and image names. If your height
field is in inches use:
picsize = nz(me.[picky height field],0)*1440

I think the section's "on format" event would be a good
place for this.

HTH

Terry

-----Original Message-----
Terry,

Thanks for the suggestion. Actually, that sounds like it would work great.
I just want to see if I understand how it works.

In my table where I have my bitmap images, I have a column for bitmap height
in twips. Then, "ON FORMAT" of the category, how do I use that stored info
to set the height?

Thanks again.

:

Beverly,


You may have to store the height of the drawing image with
your category data. You could then set the image controls
height with the category header section's "on format"
event. Remember that you need set the height in twips
(1440 twips per inch).

Probably not the solution you were hoping for. You could
check out www.lebans.com - Stephen has some pretty good
stuff on images.

HTH,

Terry

-----Original Message-----
I would like to display graphic files as part of my
category headers on a
report. The graphic files vary in height although they
all take up the same
width.

I would like the report to print the image and then the
header with no
wasted space regardless of the size of the image.

I do not want any blank spots for categories where I have
not assigned a
graphic.

Please advise.
--
Sincerely,
Beverly76
.


.

 

[Guest]

I just wanted to say thanks for all the input on this question. I think what
is going to work the best is to use subreports that are shrunk down but can
grow to full the height of the graphic. All my graphics will be one of three
fixed heights.

I could never have made it this far without the help.

With a bound OLE Frame control, simply set the Visible prop of the
control to No when the VALUE prop is NULL.

As for autosizing, it depends on the type of Image you have inserted
into the OLE field.
See:
http://www.lebans.com/autosizeole.htm
A97AutosizeOLE.zip is a database containing functionality to allow for
the auto sizing of bound or unbound OLE Frame controls.

It would be a lot easier to achieve autosizing using the standard Image
control.

--

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

Does it make any difference that I'm using a bound ole object frame instead
of an image control?

I may be in over my head here. Is there a book or online source that you
would recommend for visual basic code?

Beverly

Off the top of head .....


dim picsize as long
picsize = nz(me.[picky height field],0) ' plugs zero if no
height provided
[image control].height = picsize

Substitute your field and image names. If your height
field is in inches use:
picsize = nz(me.[picky height field],0)*1440

I think the section's "on format" event would be a good
place for this.

HTH

Terry

-----Original Message-----
Terry,

Thanks for the suggestion. Actually, that sounds like it
would work great.
I just want to see if I understand how it works.

In my table where I have my bitmap images, I have a
column for bitmap height
in twips. Then, "ON FORMAT" of the category, how do I
use that stored info
to set the height?

Thanks again.

:

Beverly,


You may have to store the height of the drawing image
with
your category data. You could then set the image
controls
height with the category header section's "on format"
event. Remember that you need set the height in twips
(1440 twips per inch).

Probably not the solution you were hoping for. You
could
check out www.lebans.com - Stephen has some pretty good
stuff on images.

HTH,

Terry

-----Original Message-----
I would like to display graphic files as part of my
category headers on a
report. The graphic files vary in height although
they
all take up the same
width.

I would like the report to print the image and then
the
header with no
wasted space regardless of the size of the image.

I do not want any blank spots for categories where I
have
not assigned a
graphic.

Please advise.
--
Sincerely,
Beverly76
.


.