field format change

  • Thread starter Thread starter BurtArkin
  • Start date Start date
B

BurtArkin

I have a table with a field set to date format. Occasionally, the user
doesn't want a date, just a year. If I give the user a checkmark to change
the date field's format, what would the code be? Or is there a simpler way?
Thanks in advance for your advice.
 
I have a table with a field set to date format. Occasionally, the user
doesn't want a date, just a year. If I give the user a checkmark to change
the date field's format, what would the code be? Or is there a simpler way?
Thanks in advance for your advice.
Click to expand...

A Date/Time field - regardless of format - always must contain a
specific point in time. 2006 doesn't work as a date field! You'll need
to do something resembling Steve's three-field suggestion, and it will
certainly make your searches more complex.
 
Back
Top