Hyperlink

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

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
 
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
 
Back
Top