Remove (or don't allow) spaces in a userform textbox

[XLVBA]

I have a userform that we are using to control our inventory. Users put in an asset "number" (combination of numbers and letters) and if it finds the asset already in the sheet it populates other fields with the information and they can make their changes. If it doesn't find the asset at all it creates a new entry for it. Since we have a lot of assets it looks for an exact match.

The problem that I have run into is if they put in a space(s) or tab(s) that it doesn't recognize it as a match, so after they fill out the form and hit submit it creates a new entry and our inventory then gets duplicates.

Is there I way I can prevent them from putting tabs or spaces in the field all together or remove them when they exit the field or enter a new one?