Hiding empty DATE fields in 4D?

Thread View: comp.sys.mac.databases

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Paul E. Jacoby Tue, 18 Aug 1992 14:03

#204

Author: Paul E. Jacoby
Date: Tue, 18 Aug 1992 14:03

27 lines
1491 bytes

(I'll post this here too for wider distribution)

Does anyone have a good way to 'hide' empty DATE fields when printing a
layout?  I have a number of date fields in a layout, any number of which
may not yet have data entered in them.  4D is happy to provide
"00/00/00" as a default value, but I don't want this value to show in
the printout!

I have played with SET COLOR( ) with no success at this point. This code
_doesn't_ work:

  If (Before & isprinting)
     If ([traveler]datein=!00/00/00!) ` date is blank
        SET COLOR(datein;0)  ` hide blank date fields
     End if 
  End if

Aside from not working, this approach is _slow_ as the Before phase
executes for EVERY record being printed.  Yuck.

* If I have to, I'll make the fields ALPHA instead of date, but I'd
  prefer to NOT make this change.
-- 
| Paul E. Jacoby, Consultant  | pejacoby@mmm.com      CIS:70404,2507 |
| David Mitchell & Associates |                                      |
| 3M Center, Bldg 235-3F-27   |--------------------------------------|
| Maplewood, MN   55144-1000  | (612) 737-3211 [w]      731-6392 [h] |

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads