Create macro to change field type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a macro to automatically go into design mode of a
table (which I can go) and change the field type in a field automatically
(which I cannot figure out how to do)..
 
Why would you want a macro to do this? Will you be doing it often?

It seems like there might be better ways to get to the end result if you
would share that with us. Typically, building a macro for something like
this can be done much more easily with code, or some type of formula to
convert data.
 
We will be doing this everynight. What we are doing is updating Hyperlink
fields. We need to change field to "text" and back to "hyperlink" to make the
hyperlink active. I do not know programming. We can activate a macro....
automatically.
 
I have read and read on this subject. I thought I would try something and it
seems to work.... We are importing a text field into a hyperlink. I read
about the # sign at the beginning and end of the field. So we "Hard-coded"
the # sign in our field we are importing into the hyperlink field and it
seems to WORK!!!!!!!
 
Back
Top