Fields defined as Hyperlinks in forms

B

Bill Murphy

I've used hyperlink field types in a continuous form to allow the user to
single click on a text hyperlink field in a row to perform some action, like
opening another form. This works well if the field content starts with text
characters. However, if the text content of the line item leads off with a
number, like "345 My Line Item Text" the user will receive the following
message in an Access dialog box with on Ok button:

Unable to open 345 My Line Item Text. Cannot open the specified file.

Is there a way to prevent this message from appearing?

Bill
 
A

Allen Browne

What version of Access, Bill?

Just tried this in Access 2003, by creating a file named "345 example.txt".
If I just typed into the field, it did not open correctly, but if i used the
Insert Hyperlink dialog (via a right-click), it worked. Using DLookup(), it
converted the contents of the hyperlink to:
345 example.txt#345%20example.txt#
so perhaps it is the presence of the space in the Address part that is
causing it to fail?
 
B

Bill Murphy

Allen,

Thanks for your response. I am running Access 2000. After posting the
message I found that in the underlying table there is a leading # entered by
the user, for example #345 example.txt. The leading # does not show when I
am in form view. And a Google search turned up a Microsoft KB article
207852 that states that including a # in a text field can cause this error
since anything after the # is truncated. The solution is to not include #'s
in text fields, so I will just have to strip out the leading # signs in the
table fields.

Bill
 
Top