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?
--
-Jacinda

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jacinda" <(E-Mail Removed)> wrote in message
news:3D37A5EE-342E-4083-B304-(E-Mail Removed)...
> 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?
> --
> -Jacinda