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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to date format? 0
Datepicker issue after changing Windows' short date time format 5
Date format in Query 1
Automate Change of the format of a field to short date for export 2
Access 2007 - Entering of datetime values in double field 1
date format 2
Properties - Format, Input Mask, Validation Rule 5
Insert into (dates format) VBA 6

Back
Top