Eliminating spaces during data entry

M

Miquel Korah

Hi I noticed that sometimes when people are entering data through a form
they tend to leave spaces. For examples in a field called "First name"
they would enter "Mary " instead of "Mary".

Is there a way that spaces can be automatically eliminated during data
entry?

How appreciate some help on this.

Thanks Miquella.
 
J

John Spencer (MVP)

Normally Access will strip off any trailing spaces entered into fields in its
tables. So that should not be occuring unless you are using tables linked to
another database product.

If you are, you can use the TRIM statement in the after update event of the
controls to get rid of any leading or trailing spaces.
 
Top