Change Formats using VBA

[Jacinda]

Hi, I have a table that collects file names via VBA . (p:\Drawing001)

When the table generates if I set the orginal property to text and then
change it to hyperlink (manually) it will automatcally open the file. I would
like to change the property using VBA so that I don't have to go into the
table to change it.

I tried setting the property to hyperlink to begin with, but that does not
seem to work...

any suggestions?

 

[Allen Browne]

If the field type is Hyperlink, you need to assign both a display value,
address, and the two # separators, e.g.:
"p:\Drawing001#p:\Drawing001#"

More info:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html