hide record/row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryanb. - 22 Dec 2003 17:20 GMT

is it possible to hide a merge record if it is equal to zero? I basically
want it Word to do what it does with a null merge field... hide it!! I have
tried using the help feature to run an if... then.. else function, but I
keep getting an error. Basically, I need it to be:

If the field is >0 show the field
Else hide the field

Any help would be greatly appreciated.

ryanb.

Word XP
Windows 2K

Reply to this Message

Graham Mayor - 22 Dec 2003 17:39 GMT

{IF {Mergefield fieldname}<> 0 "{Mergefield fieldname}"}

should do the trick.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> is it possible to hide a merge record if it is equal to zero? I
> basically want it Word to do what it does with a null merge field...
[quoted text clipped - 11 lines]
> Word XP
> Windows 2K

Reply to this Message

ryanb. - 22 Dec 2003 18:33 GMT

Thanks Graham, but where would I insert this... below is the field code that
shows while it is toggled?

{MERGEFIELD "dPP" \# "$#,##0.00 ' PER BAG' " }

I tried using the insert word field|if..then..else feature, but that is for
text only, not formulas (at least that is how it appears to me.

Thanks,

ryanb.

> {IF {Mergefield fieldname}<> 0 "{Mergefield fieldname}"}
>
[quoted text clipped - 23 lines]
> > Word XP
> > Windows 2K

Reply to this Message

ryanb. - 22 Dec 2003 19:16 GMT

allright... I was not using Ctrl+F9.... so figured that out... but how do I
get every field below the fields that hide to shift up one line? Right now,
there is a lot of blank space betweeen paragraphs when a field is hidden.

TIA,

ryanb.
Word XP
Win 2K

> Thanks Graham, but where would I insert this... below is the field code that
> shows while it is toggled?
[quoted text clipped - 35 lines]
> > > Word XP
> > > Windows 2K

Reply to this Message

Graham Mayor - 23 Dec 2003 08:10 GMT

If you are using conditional fields that only print when the content is
present, then they go on the same line, so that their lack of presence
doesn't leave a gap. You can include the line feed in the field definition
eg:

{IF {Mergefield dpp} <> "" "{MERGEFIELD dPP \# "$#,##0.00 ' PER BAG' " }
" ""}{Your next field goes here.

The above should be two lines with " ""} on the second line.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> allright... I was not using Ctrl+F9.... so figured that out... but
> how do I get every field below the fields that hide to shift up one
[quoted text clipped - 47 lines]
>>>> Word XP
>>>> Windows 2K

Reply to this Message