is it possible to have a txt field which will contain an email address and once you input teh address it becomes a hyperlink, so you can just click it and send an email from outlook?
Probably not. But why not write a click event on the email address's control that will do what you want? Additionally, you could write some code on the LOAD event of the form that sets the forecolor of the address control to blue, and the text format to "underlined". That would fool the users into believing that they are actually looking at hyperlinks...
But then again, I suppose you could always just use the hyperlink data type, as it is perfect for opening up your default e-mail program with a new message to the recipient.