how to conditionally show a picture in a document in function of a certain field when merging with a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Philip Leduc - 04 Apr 2006 02:19 GMT

Hi I know how to conditionally show text (without using VBA) and I know
VBA/VB6 from using it in MS Access , is there anybody that knows how to
conditionally show a picture in a document in function of a certain field
when merging with a database query with/or without using VBA? Thanks for
your help!

Reply to this Message

Jezebel - 04 Apr 2006 03:24 GMT

There's no direct way to do this other than write a macro that deletes or
obscures the picture according to the condition.

> Hi I know how to conditionally show text (without using VBA) and I know
> VBA/VB6 from using it in MS Access , is there anybody that knows how to
> conditionally show a picture in a document in function of a certain field
> when merging with a database query with/or without using VBA? Thanks for
> your help!

Reply to this Message

Jean-Guy Marcil - 04 Apr 2006 14:08 GMT

Philip Leduc was telling us:
Philip Leduc nous racontait que :

> Hi I know how to conditionally show text (without using VBA) and I
> know VBA/VB6 from using it in MS Access , is there anybody that knows
> how to conditionally show a picture in a document in function of a
> certain field when merging with a database query with/or without
> using VBA? Thanks for your help!

You could try with an IF field:

{IF {MERGEFIELD name}= "Some value" "(Inline picture)" "Else nothing"}

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Reply to this Message

Philip Leduc - 04 Apr 2006 16:22 GMT

Making the picture "inline" did the job, thanks. I needed that extra
knowledge from word, thanks!

> Philip Leduc was telling us:
> Philip Leduc nous racontait que :
[quoted text clipped - 8 lines]
>
> {IF {MERGEFIELD name}= "Some value" "(Inline picture)" "Else nothing"}

Reply to this Message