Dezii:
First of all, thank you for being so responsive. However, I am getting an error message now that says "Compile Error: User-defined type not defined." Can you walk me through this. I'm sorry for my ignorance on this topic. Let me tell you what I did first.

I went into Access, opened my form in Design view, when to the "picture_c" field box, right-clicked in the field box, selected <Build Event>...

Hi Dezii,
Thanks for writing that code for me. However, I am getting an error when I run the script.

I was hoping you could help me troubleshoot the script.

My first question is...

Should I be changing the "MyDB" value to the name of the database (Control 05-20-10), at every instance that it occurs within the script? I did try doing this as well and it still came back with an error. I...

To ADezii:
Thank you for responding.
On questions 1 & 2: Yes, I mean that I only want the field to display the actual address (path) to the file, not the "alias" name that appears before the hyperlink. When I take the table and import it into, for instance, ArcMap and view the attribute table, the links do not work inside ArcMap because the alias is displayed in front of the encapsulated address.

To NeoPa:...

I have a huge database that contains hyperlinks to many different Survey Monument Images. The current database has an "Alias" address and an #encapsulated# link address. I need to be able to bring the Access DB into ArcMap, so the alias's need to be taken out completely. I really do not have much experience using VBA in Access and was wondering if anyone would be able to help me figure out how to get this to work. The field is named "Picture_c"...