Automated Hyperlink using concatenation

[speoples]

I am trying to create an automated hyperlink in a form, based off of another field. Here is what I have so far in the after update event:

ParkerDrawingHyperlink = "#C:\Documents and Settings\shapeo\My Documents\CYLINDERS\Cylinder Drawings\#" & Me.ParkerDrawing & "#.pdf#"

This is working up to a point. It is opening the file folder on my hard drive where all the files are stored, but it is not opening the actual file.

When I look at the automated field, the following result is being populated:

C:\Documents and Settings\shapeo\My Documents\CYLINDERS\Cylinder Drawings\ - gc613058a0

The "gc613058a0" is the name of the file it should be opening. I don't understand why it is adding the extra spaces and hyphen before it though.

Any ideas?

[speoples]

Ok, played around with it some more and finally figured it out. YEA!!!!

Here is how it should read:

ParkerDrawingHyperlink = "#C:\Documents and Settings\shapeo\My Documents\CYLINDERS\Cylinder Drawings\" & Me.ParkerDrawing & ".pdf#"

[TheSmileyCoder]

I think you have some confusion about the use of #. They are normally used around DATES to indicate that they are dates and not merely a calculation. I suggest you take the time to look at these 2 articles to get a better understanding of the concept:
Literal Datetimes and their delimiter #
Quotes (') and Double-Quotes (") - Where and When to use them.

[Hoopla3000]

@TheSmileyCoder
A hyperlink entry contains three parts separated by pound signs (#). The template is:

display text # file name # any reference within the file

The following link explains in more detail:
http://allenbrowne.com/casu-09.html

Hyperlink fields can be challenging to work with if you don't use them a lot. For storing paths where a clickable hyperlink is not needed, I have had less frustration by using ordinary text fields and using a button to launch the path.

[TheSmileyCoder]

Thank you Hoopla3000, for that explanation. As you can probably guess I don't work with hyperlinks alot, I just use ordinary text fields, and a button to launch the links, which are usually files on our server.

[NeoPa]

Good pickup Hoopla. I asked a question on this some time ago and the thread may prove helpful to those interested Error 7980: HyperlinkAddress or HyperlinkSubAddress read-only for Hyperlink. I believe I linked into Allen Browne then too as it happens.