How to make a field accept No spaces

[jhjarvie]

I have a field called 'txt_Part_Number' and I would like this field to accept any letters or numbers but NO spaces!!

Any ideas how to do this?

[dcrake]

You could tackle this in 2 ways

1. use the keypress/keydown event on the control to test for a space, and if encountered issue a backspace.

2. on the before/after update event use Replace(Me.ActiveControl," ","") to trim out any spaces.

David

[jhjarvie]

You could tackle this in 2 ways

1. use the keypress/keydown event on the control to test for a space, and if encountered issue a backspace.

2. on the before/after update event use Replace(Me.ActiveControl," ","") to trim out any spaces.

David

Looks good, but I am getting a compiler error......."Expected = "
Any ideas??

[jhjarvie]

Looks good, but I am getting a compiler error......."Expected = "
Any ideas??

Silly me!! I have it now, albeit a slightly different coding.......

Me.Part_No = Replace(Me.Part_No, " ", "")

Thanks for the help

[RuralGuy]

Are you satisfied enough to use the Solved thread tool?