Validate input field to filter out certain characters

[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 ?

 

[Carl Rapson]

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 ?

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

 

[Smiley]

Hi Carl,

Thank you.

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

 

[missinglinq via AccessMonster.com]

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