blank fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mary - 08 Sep 2004 20:16 GMT

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!

Reply to this Message

Cindy M -WordMVP- - 13 Sep 2004 20:02 GMT

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

:-)

Reply to this Message

Mary - 15 Sep 2004 16:58 GMT

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

>-----Original Message-----
>Hi Mary,
[quoted text clipped - 21 lines]
>
>.

Reply to this Message

Graham Mayor - 15 Sep 2004 17:29 GMT

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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thanks for the reply. The IF field returns {Mergefield
> TheDate} in my form. I tried variations but it comes out
[quoted text clipped - 26 lines]
>>
>> .

Reply to this Message

Mary - 16 Sep 2004 16:17 GMT

Thank you! Made me feel stupid but it works!

>-----Original Message-----
>You need to use CTRL+F9 for each pair of field boundaries not {}.
[quoted text clipped - 33 lines]
>
>.

Reply to this Message

Graham Mayor - 16 Sep 2004 17:58 GMT

We've all been there ;)

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thank you! Made me feel stupid but it works!
>
[quoted text clipped - 44 lines]
>>
>> .

Reply to this Message