Hyperlink

[kevcar40]

Hi
i have two fields in a table that are concantinated together
field 1 contains the path to the folder (formatted as Hpyerlink)
field 2 contains the name of the file (formatted as Hpyerlink)
field 3 concants field 1 and 2 (formatted as Hpyerlink)
i am concanting using = [field1] & [field2]
the problem i have when joined together field 2 is putting a - at the start of the string
How do i stop this happening

thanks

Kevin

 

[John W. Vinson]

Hi
i have two fields in a table that are concantinated together
field 1 contains the path to the folder (formatted as Hpyerlink)
field 2 contains the name of the file (formatted as Hpyerlink)
field 3 concants field 1 and 2 (formatted as Hpyerlink)
i am concanting using = [field1] & [field2]
the problem i have when joined together field 2 is putting a - at the start of the string
How do i stop this happening

thanks

Kevin

Field 3 should simply NOT EXIST.

Storing data redundantly in a table is bad design. It's all to easy to (say)
edit the path in Field1 and not remembering to edit it in Field3.

I'd simply store the filename and path in two Text fields (not Hypterlink);
you can construct the hyperlink as needed in code.

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com