Overlaying Text and Image (1 Viewer)

RogerCooper

Registered User.
Local time
Today, 11:10
Joined
Jul 30, 2014
Messages
288
I have an application where each record has both text and an associated image. I would like to print both the text and image on top of each other in Access (in the context it should be legible). Is this possible in Access?

I suppose that I could create 2 reports and run the page through the printer twice, but I like a cleaner solution and be able to create a pdf easily.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:10
Joined
Oct 29, 2018
Messages
21,538
Not in front of a computer now, but are you saying you can't put a Textbox on top of an image in a report? Sounds like it should be possible.
 

isladogs

MVP / VIP
Local time
Today, 19:10
Joined
Jan 14, 2017
Messages
18,261
You could set the z-order so the textbox is at the top but if the textbox background is
1. Transparent - the text may be hard to read
2. Normal - the text will be legible but part of the image will be hidden
Why not just print the text above/below/next to the image?
 

RogerCooper

Registered User.
Local time
Today, 11:10
Joined
Jul 30, 2014
Messages
288
You could set the z-order so the textbox is at the top but if the textbox background is
1. Transparent - the text may be hard to read
2. Normal - the text will be legible but part of the image will be hidden
Why not just print the text above/below/next to the image?
How do I set the z-order? The image seems to block the text box, even if the text box is transparent.

I am printing counters for a board/miniatures game, so space is very limited (1.5" x .75").
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 14:10
Joined
May 21, 2018
Messages
8,605
Right click on control
Select "Position"
Select "Bring to Front"
 

isladogs

MVP / VIP
Local time
Today, 19:10
Joined
Jan 14, 2017
Messages
18,261
You can also do this using code e.g. by clicking on the image then setting the focus on the textbox
You can also use DoCmdRunCommand acCmdBringToFront but only in design view
 

RogerCooper

Registered User.
Local time
Today, 11:10
Joined
Jul 30, 2014
Messages
288
Right click on control
Select "Position"
Select "Bring to Front"
That works. Here is the result:
1661551390816.png


Is there any way to get the image to center? The images I will be using may vary in size. The image seems to on left side of the control regardless of what I do.

1661551692393.png
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 14:10
Joined
May 21, 2018
Messages
8,605
Did you try the properties
Size Mode (zoom, stretch, clip)
Picture Alignment (center,top left, top right, bottom left, bottom right)
 

CarlettoFed

Member
Local time
Today, 20:10
Joined
Jun 10, 2020
Messages
120
Sorry maybe it's easier and quicker to help you if you attach a sample file.
 

RogerCooper

Registered User.
Local time
Today, 11:10
Joined
Jul 30, 2014
Messages
288
I was able to get everything to work. Thank you all for your help.
 

Users who are viewing this thread

Top Bottom