Date needs to be text sometimes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that needs to have a date in it. It is used in parameter
queries frequently. However, there are times when "TBA" needs to be in that
box instead. Is there a way to get a short date format where it can be used
to search & yet have text show if no date is known yet?
 
Once a field is set as a datatype of date, you can't set text values within
that field. However, you can display this on a form by creating a textbox
control with this info in the Control Source under the textbox properties:
=IIf([CheckedDate]>0,"","TBA")where [CheckedDate] is your date field name.
Place this textbox next to the date field on the form. When a user types in
a date, the TBA will disappear, if the date gets erased the TBA will return.
 
Back
Top