I've created a Links List in MOSS 2007 and am trying to use an IP 2003 form to retrieve the items from this list into the Form. That isn't a problem but what I encounter is the Hyperlink attached to the List Item containst both the URL and the "Description" from the original List Item in MOSS (see below). What then happens is in the IP 2003 Form the Hyperlink concatenates both the URL and Description into a single URL which now doesn't have the correct address. Is there something I'm overlooking when Retrieving the List data from my Sharepoint list or is this something I'm stuck with in the absence of custom code? Here's an Example:
SharePoint Item in a "Links" list:
URL: http://www.anysite.com, Description: An interesting site showing nothing important
InfoPath Display of above mentioned List Item: http://www.anysite.com,%20an%20interesting%20site%20showing%20nothing%20important/
This is real frustrating because now every time the user of the Form wants to view the link he must click on the hyperlink, get annoyed with the error message on the screen, then manually erase the appended URL extension of the "Correct" address before the hyperlink launches correctly. What am I missing here? and how can I get this to work properly.