Hiding blank dates in a grid

I know this is simple but I can't remember it.

I am displaying dates in a grid, and some of the date fields are empty. If
the date field is empty, how do I stop the cell displaying / / because
I just want it to display a blank box if there is no date.

Sincerely

Stephen

AtoutFox
Thu Apr 03 06:13:15 CDT 2008

dynamicforecolor ... ?
iif(empty(myDate), RGB(255,255,255), RGB(0,0,0))

"Stephen Ibbs" <stephen@datadevelopments.co.uk> a écrit dans le message de
groupe de discussion : eYWuuLXlIHA.980@TK2MSFTNGP06.phx.gbl...
> I know this is simple but I can't remember it.
>
> I am displaying dates in a grid, and some of the date fields are empty. If
> the date field is empty, how do I stop the cell displaying / /
> because I just want it to display a blank box if there is no date.
>
> Sincerely
>
> Stephen
>
>

Bernhard
Thu Apr 03 06:19:16 CDT 2008

Hi Stephen,

> I know this is simple but I can't remember it.
>
> I am displaying dates in a grid, and some of the date fields are empty. If
> the date field is empty, how do I stop the cell displaying / / because
> I just want it to display a blank box if there is no date.
See .Format property, code "Z"

Regards
Bernhard Sander

Stephen
Thu Apr 03 07:37:36 CDT 2008

Many thanks both. It was the format property Z I had forgotten.

Stephen

"Bernhard Sander" <fuchs@no.spam> wrote in message
news:ep9DKyXlIHA.464@TK2MSFTNGP02.phx.gbl...
> Hi Stephen,
>
>> I know this is simple but I can't remember it.
>>
>> I am displaying dates in a grid, and some of the date fields are empty.
>> If the date field is empty, how do I stop the cell displaying / /
>> because I just want it to display a blank box if there is no date.
> See .Format property, code "Z"
>
> Regards
> Bernhard Sander

AtoutFox
Thu Apr 03 11:42:24 CDT 2008

I had the same need with 31.12.9999 where Z property doesn't work ...

My apologies for the misguidance

François37

"Stephen Ibbs" <stephen@datadevelopments.co.uk> a écrit dans le message de
groupe de discussion : ur8$BeYlIHA.4196@TK2MSFTNGP04.phx.gbl...
> Many thanks both. It was the format property Z I had forgotten.
>
> Stephen
>
> "Bernhard Sander" <fuchs@no.spam> wrote in message
> news:ep9DKyXlIHA.464@TK2MSFTNGP02.phx.gbl...
>> Hi Stephen,
>>
>>> I know this is simple but I can't remember it.
>>>
>>> I am displaying dates in a grid, and some of the date fields are empty.
>>> If the date field is empty, how do I stop the cell displaying / /
>>> because I just want it to display a blank box if there is no date.
>> See .Format property, code "Z"
>>
>> Regards
>> Bernhard Sander
>
>