Hyperlinks > 128 characters bomb out my add record query!?!?!?!

  • Thread starter Thread starter wazza_c12
  • Start date Start date
W

wazza_c12

Hi All

This is driving me nuts

I have an unbound form with a hyperlink field / browse function to
select a file on the network.
When a save button is pressed a query is called and a new record added
to a table using the unbound form fields.

Everything works perfectly EXCEPT.....

When the hyperlink form field is greater than 128 characters.... it
errors when the query is run.
I can manually paste a longer address directly into the table and it
works fine, it only bombs out when the query runs, and only when its a
long link.

The error I get is "Runtime error 3001 - invalid argument"

What the hell is going on?!?!?!

Please Help

Warwick
 
When storing a hyperlink, Access normally stores both "display text" and
the actual URL. By default, these are the same - i.e. it stores two
copies of the url, e.g. :

http://www.microsoft.com#http://www.microsoft.com

so there's obvious scope for problems if you are using a Text field to
store the hyperlink. Use a Hyperlink or Memo field instead.

If that's not the answer, please post back with more information on just
what your code is doing.
 
Back
Top