Allowed Entry Formats

[billgyrotech1]

Hello,



I have a PO # field that can have 3 different types of data entered:

P-56589
(If the part came from a purchase order number)

W2003:001
(If the part came from a house work order number)

AFR55555
(If the part came from an AFR number)

Is there a way to ensure no spaces are entered by the user or spaces removed when they leave the field?

Thank you,
Bill

[pbaldy]

You can do this type of thing (I think that's the right code for a space):

Private Sub txtRequestor_KeyPress(KeyAscii As Integer)
  Select Case KeyAscii
    Case 32
      KeyAscii = 0
    Case Else    
      KeyAscii = KeyAscii
  End Select


End Sub

[billgyrotech1]

I put it in the key press event but it doesn't work for taking out spaces sorry.

[pbaldy]

It doesn't take them out, it prevents them from being entered. I just tested and it worked as expected.

[billgyrotech1]

Thanks pbaldy it does work I was entering the code incorrectly.

[pbaldy]

No problemo.