New at Access. Have a date field. But I need
it to be text because month and maybe day is
unknown. Form is already completed.
Is this possible without deleting the field?
Thanks in advance
The form is almost completely irrelevant to this issue; it's just a
window, a tool to view and edit data in the Table. You need to change
the field type form Date/Time to Text in Table design view.
This should succeed if there is not *too* much (tens of thousands of
records say) data already in the table. The dates currently in the
table will be converted to the format specified in your Windows
Control Panel/Regional and Language date/time format settings. You
might want to change this setting temporarily to a value which will
sort correctly, such as yyyy-mm-dd. If you'll never be searching or
sorting by date, don't bother - just leave the setting the way you
want the date displayed.
Once you've changed the field type in the Table, your form should
still work. If it doesn't, post back explaining how it fails.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps