Hyperlink problem in form

[G1ZmO]

In the table which is the source data for my form I have a field Info_Link whos Data Type is set to be a hyperlink and this looks/works ok when the table is viewed as a table.

However when viewing the data in a form the hyperlink field value has # symbols on either end of the hyperlink and doesnt function as a hyperlink.

I tried setting the "Is Hyperlink" property but this didnt remove the #s

Any suggestions?

Thanks

Paul

 

[ansentry]

Attached is a working sample. compare it with yours and see what may be wrong.

 

[G1ZmO]

Thanks

If I add the field directly to a form then the link works but if I fill a text box with the column value from a combo box (as I'm trying to do) it doesn't work

Sorry I should have explained that

Attached is the db file

Thanks

Paul

 

[G1ZmO]

btw if I pass an email address through a combo box by the same method it does the same thing #email@domain.com#

btw is there a limit to the number of fields that can be passed via a combo box?

Paul

 

[G1ZmO]

Nobody got any ideas about the hyperlink problem?

Paul

 

[JohnLee]

Hi

In your table, where you have your datatype set to hyperlink, set the unicode compression to "Yes", and see if this makes a difference

John