Thanks for the suggestions. I'm still having a problem with the formula though. I was getting error messages with this formula:
if isnull(tblGrantRevisit.SubmittedToPandC) then 'Missing' else totext(tblGrantRevisit.SubmittedToPandC,'MM/dd/yyyy')
Until I changed it to this formula:
if isnull ({tblGrantRevisit.SubmittedToPandC}) then 'Missing' else totext ({tblGrantRevisit.SubmittedToPandC},'MM/dd/yyyy')
Now, instead of the NULL values showing 'Missing', there's a date displayed as 12/31/-4714.
Not sure how it's coming up with that date?