Hyperlink in Text Box on form

[GF2002]

I have a database that creates tables on other databases once information is stored. I use the following format to create a new table from this form:

Set field(122) = TableName.CreateField("WhiteCar", dbText, 255)

which works fine. The text box then lets the user enter information and once they click a cmd button, it creates a new table on a seperate database. However, when I try to use this format:

Set field(122) = TableName.CreateField("WhiteCar", dbHyperlink, 255)

for the text fields that will allow the user to input a hyperlink, it get the following error:

"Data type conversion error."

Please note: The text fields are all UNBOUND.

Any help is appreciated. Thanks!

 

[MazeWorX]

This is because Hyperlink is not a valid "Data type"

See Type Property in visual basic help

You could store the data in the db as text then pass it at run time to a function to create a hyperlink.


Theres a good example of this in Access VB Help under Hyperlink Property


hth Remember amateurs built the ark - professionals built the Titanic

[flush]