Email Field Problem

[bw]

I have just installed Access on a new computer, so some settings may not be
correct.
I have a table with a field used for an email address. Field Name is Email,
Data Type is Text, and Field Size is 50.
I can enter the email address in the table just fine.

When I try to enter the email address in the form field, I get the following
message:
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."

When I close this message box, the cursor is flashing at the end of the
email address, and when I click on that point, it shows the "value" in the
field, and explains why I am getting that error message.

I enter the following in the field: (e-mail address removed)
When I click on the flashing cursor after the last character, it looks like
the following has been entered:
[email protected]#http://[email protected]#

Can someone explain why this is so?

Thanks,
Bernie

 

[Brendan Reynolds]

I have just installed Access on a new computer, so some settings may not be
correct.
I have a table with a field used for an email address. Field Name is
Email, Data Type is Text, and Field Size is 50.
I can enter the email address in the table just fine.

When I try to enter the email address in the form field, I get the
following message:
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."

When I close this message box, the cursor is flashing at the end of the
email address, and when I click on that point, it shows the "value" in the
field, and explains why I am getting that error message.

I enter the following in the field: (e-mail address removed)
When I click on the flashing cursor after the last character, it looks
like the following has been entered:
[email protected]#http://[email protected]#

If you have the 'IsHyperlink' property set to 'Yes', Access will add the
additional "#http://[email protected]#" as that is what is required in
order for the control to function as a hyperlink, i.e. to launch your e-mail
program and insert the e-mail address when you click on the text box. If you
don't need the hyperlink functionality, you can change the 'IsHyperlink'
property to 'No', otherwise you'll need to increase the size of the field.