Want default date to be N/A

[DanEaton]

I am currently creating a catalog database, and filing all of the catalogs. I have a report that creates labels for each catalog as it is entered. The labels have two different characteristics: catalog date, filed under. Catalog Date is a field on tblCatalog that is not required to be entered. I want it to set to a default string "N/A" (for obvious reasons) if nothing is entered. Is it possible to write some simple code to overwrite the input mask? It is set to date/time. The data entry form is called frmCatalogDataEntry.

Thanks in advance.

Dan Eaton

 

[jgoodman00]

If the data-type is set to date time, then it will not allow entry of n/a unfortunately... James Goodman

http://www.james-goodman.co.uk

 

[DanEaton]

There's no code that will overwrite that? Is there anyway I could get N/A on the report but not stored in the table? I don't care if it gets stored as long as it is on the labels. Anyone?

Dan Eaton

 

[jgoodman00]

I guess you could use the Nz function, but this will require the user not submitting a value into the date field.

Your report controlsource for the date field would need to be something like:

=Nz("[Catalog Date]", "N/A&quot


I think that will assign N/A to records where the catalog date is null... James Goodman

http://www.james-goodman.co.uk

 

[DanEaton]

I used the conrol source method but instead used
=IIf(IsNull([CatDate]),"N/A",[CatDate])
Thanks for setting me on the right track!

Dan Eaton