Prev: me
Next: 回覆: Query Designer font is so small.
From: FinishRich2025 on 2 May 2010 22:18
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
From: Tom van Stiphout on 3 May 2010 09:54
On Sun, 2 May 2010 19:18:17 -0700 (PDT), FinishRich2025
<finishrich2025(a)gmail.com> wrote:

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



>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
 | 
Pages: 1
Prev: me
Next: 回覆: Query Designer font is so small.