Field Contents doubledup (1 Viewer)

[ianclegg]

I would appreciate any help with my problem

I am using a subform within a form to select data from a field, the records field is defined as a hyperlink which contains the location of a pdf file.

When I use me.datadisplaysubform("report") to retrieve the data, I find that the field contents get doubled up into the output variable

eg c:\test becomes c:\test#c:\test

Thanks in anticipation


Ian Clegg

 

[isladogs]

Hyoerlink fields are difficult to use as they actually contain two parts-the link itself and how it is displayed.
This is probably why you're seeing double

Use a text field for the file location instead.
Then use code similar to

Application.FollowHyperlink 'file path'

Substituting with the actual file path

 

[ianclegg]

Thanks again for the help, I changed the field type to Text and deleted the second half.

Now it works OK.

Regards

 

[isladogs]

No problem.
FWIW I NEVER use Hyperlink datatype for this reason