I was given a solution in this question:
TextDrive = ServerLink
strDrive = Left(TextDrive, 2)
Set objWMI = GetObject("winmgmts:\\.\ro
Set colDisk = objWMI.ExecQuery("Select * From Win32_LogicalDisk Where DeviceID='" & strDrive & "'")
For Each Item In colDisk
ServerLink = Replace(TextDrive, strDrive, Item.ProviderName)
That converts a network drive letter to a UNC path. It worked great until I tried using it on a field that was formatted for a hyperlink. I think that the automatic # symbols that are put at the beginning and end of the link are screwing it up because it doesn't do anything now. How would I modify this for a hyperlink field?