date/time

[Guest]

Is there any way to make an exception for date/time field types so that it
reads NA instead of just leaving it blank? I mean instead of having a date or
blank square in a record it reads NA so that it is easy to read.

 

[Jerry Porter]

If your field were named DateField, you could use the following
expression:

NZ(DateField,"NA")

NZ changes Nulls to Zero, or to any value you specify.

If you're using it in a form, it would be
=NZ(DateField,"NA")
and make sure you change the name of the text box so it isn't the same
as the field name (e.g. name the control txtDateField).

Jerry

 

[Guest]

Hi.

In A2K, the following works in the Format property for date fields in
Tables, as well as TextBox controls on Forms and Reports:
mm/dd/yyyy;;;"N/A"

-Michael

 

[Jerry Porter]

Michael,

I think yours is a better solution than mine. It just changes the
displayed format, instead of the actual value.

But if someone were testing for a value in a form or elsewhere, they
would need to know to check for Null instead of "NA".

Jerry