Macro to change fieldtype

J

Jan van Hooff

How can I change the type of a field from text to date/time with a macro?
 
S

Steve Schapel

Jan,

Use a RunSQL action in your macro. In the SQL Statement argument, put
the equivalent of...
ALTER TABLE NameOfYourTable ALTER COLUMN NameOfField DATE
 

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

Select Text to End of Footnote 9
Need Help with Macro Security 1
VBA word change keys 0
Change a great number of words in word files, with a macro as short as possible. 5
Clearing Fields in a Word Form 5
Macro to select and delete levels of a document 2
Find and replace macro for Special ^p - MS Word 0
Countdown macro - display settings 2

Top