How to use a hyperlink field

[SAC]

I have a textbox on a form whose datasource is a hyperlink field.

I'd like to enter a directory path so when the user clicks on it it opens
windows explorer to the folder.

For testing I have the following code:

I set the path and then make the directory.

Me!DirectoryPath = "C:\123"
MkDir (Me!DirectoryPath)

But when I click on the control it doesn't open the folder.

What do I need to change?

Thanks.

 

[SAC]

Thanks!

Oroginally, the user clicks the button to make a path which is stored in the
hyperlink field of the table.

Is there a certain format or can I just store the "C:\123" in the hyperlink
field?

Thanks.

 

[SAC]

What is would really like to do is to store the path in the hyperlink filed
and allow the user to click on it to open up the folder.

What is the format to put in the field.....I'm trying "C:\123" but this
doesn't work.

What can I do?

Thanks.

 

[SAC]

Thanks for your help. I was able to figure it out.