Validate input field to filter out certain characters

  • Thread starter Thread starter Smiley
  • Start date Start date
S

Smiley

Hi,

I am on MSAccess 2000 and I want to valid a field before going on to next
field when user inputting data.

My so call validation is just change certain input characters into space or
just remove such character.

For example, if user input abcd's or abc@erews, I want the final data look
like either abcds or abcd s for abc@erews will look like abc erews or
abcerews.

Anyone any idea ?
 
Smiley said:
Hi,

I am on MSAccess 2000 and I want to valid a field before going on to next
field when user inputting data.

My so call validation is just change certain input characters into space
or just remove such character.

For example, if user input abcd's or abc@erews, I want the final data look
like either abcds or abcd s for abc@erews will look like abc erews or
abcerews.

Anyone any idea ?
Click to expand...

Use the KeyPress event to filter out any characters that are not allowed.
Alternatively, you could use the AfterUpdate event to scan the entire string
and replace/remove the characters you don't want.

Carl Rapson
 
Hi Carl,

Thank you.

Carl Rapson said:
Use the KeyPress event to filter out any characters that are not allowed.
Alternatively, you could use the AfterUpdate event to scan the entire
string and replace/remove the characters you don't want.

Carl Rapson
Click to expand...
 
This code prevents certain characters from being entered. In this case, it's
A and B, but you can replace the 65 and 66 with the ASCII code for any
character you wish.

Private SubYourTextBoxName_KeyDown(KeyCode As Integer, Shift As Integer)

Select Case KeyCode

Case 65, 66
KeyCode = 0

End Select

End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Back
Top