Restricting field contents to Alphabetic characters only

• • Reply

  14 years ago

  by justme1310

  winston

  , Trinidad and Tobago

  Joined 14 years ago

  Hello everyone,
  
  I'm working on a data-entry form and would like to restrict the data that I enter on certain fields to alphabetic characters only i.e. a -z, A - Z and Spaces.
  
  Is there any way I can acomplish this??
  
  Many thanks in advance.
  
  
  Will
  
  
  
  
  
  
  
  
  

  Report abuse
• • Reply

  14 years ago

  by tpuig

  Terence

  Iloilo, Philippines

  Joined 15 years ago

  hi,

  I didn't touch my computer for a couple of months, but try this one...

  On keypress event of your textbox...

  Private Sub TextBox_KeyPress(KeyAscii As Integer)
      If KeyAscii < 65 Or KeyAscii > 129 Then        'for a - z and  A - Z only
          KeyAscii = 0
      End If
  End Sub
  
  
  
  
  
  

  Report abuse