Access 97 Output Mask

  • Thread starter Thread starter Rog
  • Start date Start date
R

Rog

Hi all

i have a table with a date field, that allows nulls

When the data is displayed in a tabular form, if the field
is null, i'd like to display "nya" instead - is this
possible? If so, how?

Thanks

Rog
 
"yyyy-mm-dd;;;\n\y\a"

(or whatever date format you want, then 3 semi-colons followed by \n\y\a.)
The slashes are escape characters so that the letter following isn't
interpretted as a format.
 
Superb. Thanks

Rog

-----Original Message-----
"yyyy-mm-dd;;;\n\y\a"

(or whatever date format you want, then 3 semi-colons followed by \n\y\a.)
The slashes are escape characters so that the letter following isn't
interpretted as a format.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.
Click to expand...
 
Back
Top