Text and Graphics together in reports

[FinishRich2025]

I hope I can explain this properly. In my database (2007), I have
records with a question and 4 answers. Some of the questions are
pictures (saved as BMP files in OLE Object fields) and others have
only text (memo field). I basically have 2 question fields (one text
and one picture) and 2 fields for every answer (in case I need either
one or both - hence my problem).

On some of those questions, they have text before and after the
graphic:

This is what we have:
[image]
What is the answer?

What I am curious about is how to display this in a report? Can the
text and graphic part be combined? In the text questions, I imbedded
CRLF and the text "[image]" in an attempt to figure it out, but
nothing I search for is coming up with an answer (if there is one).

Is this possible? If so, how?

Thanks !!!!
Tim

 

[Tom van Stiphout]

On Sun, 2 May 2010 19:18:17 -0700 (PDT), FinishRich2025

No, you would simply display:
textbox1
bound ole object
textbox2

Each control would be bound (ControlSource) to its field in the
underlying query.
You can set CanGrow and CanShrink to true, so the controls would not
take up space if there is no data.

-Tom.
Microsoft Access MVP