Wortz, Charles
CWortz at tea.state.tx.us
Tue Jul 29 13:59:59 CDT 2003
Mark, Why would you want to make such a change at execution time? That is the type of decision you are supposed to make at design time. If you must do it in code, then use DDL to create a new field, update it with the converted value from the old field, and then delete the old field. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] Sent: Tuesday 2003 Jul 29 13:33 To: AccessD at databaseadvisors.com Subject: [AccessD] Change field data type programmatically How can I change a data type in code? I want to change Field1 from Date/Time to Text. Any ideas? Thanks, Mark Boyd Sr. Systems Analyst McBee Associates, Inc.