Removing all spaces in an email string

[shuddle]

I have the field Email in the form Fm_Data_Entry where there are spaces that were uploaded with the data. I want to put in some kind of TRIM in the field's Event so that it will correct those that are already in there and any that may be added in the future. I don't know how the script should go. Any help would be appreciated.

[kd2017]

Run a query like this to delete all the spaces in the table:

UPDATE [table name] SET [table name].[email field] = Replace([table name].[email field], " ", "");

And use the same replace function in your form's before update event to remove spaces the user might enter in the form

Me![email field] = Replace( Me![email field] , " ", "")

[Micron]

If you can, the expedient thing to do is remove them as part of the upload process, otherwise they are there until you manually fix it.

[shuddle]

Those worked great, however I'm still getting some duplicates when I group the emails. Most are combining to one email but there is a hand full that are not. I thought it was because of spaces in the emails but I can't see anything different. Is there a way to weed out duplicate emails rather than grouping them?

SELECT Tbl_DO_Stakeholder_data.Email
FROM Tbl_DO_Stakeholder_data
GROUP BY Tbl_DO_Stakeholder_data.Email;

[Welshgasman]

Those worked great, however I'm still getting some duplicates when I group the emails. Most are combining to one email but there is a hand full that are not. I thought it was because of spaces in the emails but I can't see anything different. Is there a way to weed out duplicate emails rather than grouping them?

SELECT Tbl_DO_Stakeholder_data.Email
FROM Tbl_DO_Stakeholder_data
GROUP BY Tbl_DO_Stakeholder_data.Email;

Use DISTINCT ?

[shuddle]

I found the problem. Some of the names have a return (extra line under it). How would I correct this?

[orange]

Please show an example of this record with (extra line under it).

[shuddle]

I'm unable to upload the example due to security on my computer.

I will just correct them manually in the initial upload. After that it shouldn't be a problem.

Thank you for your help.

[kd2017]

UPDATE [table name] SET [table name].[email field] = Replace([table name].[email field], vbCrLf, "")