[AccessD] Report Replacing Text with Image

[David Emerson]

Hi team,

I have tried to implement Rocky's suggestion.  The problem I have
encountered is that when I create a field in the report query that splits
the text, the control on the report will not accept a Text Format of Rich
Text.

If I change the source of the control back to the raw field the control can
be changed to Rich Text .

Any suggestions of how I can get around this?

Thanks all

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Monday, 28 March 2016 11:24 a.m.
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Report Replacing Text with Image

David:

In the detail section of the report I would place two text boxes and the
image - one text box above the image, one below.  Then, in the format event
of the detail section of the report I would split the rtf text with the word
[image] in it.  Using Instr, find the end of the first section of text put
that in the text box above the image, and the second part of the rtf after
[image] in the second text box.

Would that work?

Rocky Smolin
Beach Access Software
858-771-1869
www.bchacc.com
www.e-z-mrp.com
Skype: rocky.smolin
 


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
John Bodin
Sent: Sunday, March 27, 2016 3:13 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Report Replacing Text with Image

Hi David,

I seem to remember Stephen Lebans had something that would allow you to do
this but there was a limitation as to where the picture was to be placed
(like text could not wrap around it or something like that.)  That would be
old Code as he stopped doing Access a while ago.  I used it in an app some
time ago (http://www.lebans.com/richtext.htm)

Had this in a .Net link that might give some insight into RTF fields (too
much for me)

http://www.codeproject.com/Articles/4544/Insert-Plain-Text-and-Images-into-R
ichTextBox-at-R

Good luck,

John

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Sunday, March 27, 2016 5:31 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Report Replacing Text with Image

Hi Listers,

Access 2013, SQL 2012 BE.

I have a report with a subreport.  The subreport is a continuous report with
a single field representing a paragraph of text.  The data is stored in Rich
Text format.  In the middle of one of the paragraphs is the text "{Image}".
When the report is printed I want the text "{Image}" to be replaced with an
actual image.  The image is the same for all reports.  However the location
of the paragraph on the report is not fixed as it depends on what paragraphs
are selected for the report.

Any suggestions how I can achieve this?