blank fields

[Mary]

I am using Word 2002 and a Works 7.0 database. There are
some date fields that show up "12:00:00 AM" when the
field is blank in the database. Not all date fields do
this.
Thanks for any help!

 

[Cindy M -WordMVP-]

Hi Mary,

I am using Word 2002 and a Works 7.0 database. There are
some date fields that show up "12:00:00 AM" when the
field is blank in the database. Not all date fields do
this.

You could try using an IF field to test the data the
mergefield is showing. Roughly:

{ IF "{ Mergefield TheDate }" = "12:00:00 AM" "" "{
Mergefield TheDate}" }

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Mary]

Thanks for the reply. The IF field returns {Mergefield
TheDate} in my form. I tried variations but it comes out
about the same.

 

[Graham Mayor]

You need to use CTRL+F9 for each pair of field boundaries not {}.
If then the field description is shown rather that the content, toggle the
display with ALT+F9.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Mary]

Thank you! Made me feel stupid but it works!

-----Original Message-----
You need to use CTRL+F9 for each pair of field boundaries not {}.
If then the field description is shown rather that the content, toggle the
display with ALT+F9.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>





.

 

[Graham Mayor]

We've all been there

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>