Thank you....Your Responses have helped me solve part of my dilema. Now for the new one....I am using the following code (Partial) to determine how many characters are in the input text box. The code works properly the first time I use it.
I use If then statements to determine the actions based on how many characters the user enters.
What happens is that after the first time the code is used, the aupc text box is padded with a blank character "12345678911 " instead of "12345678911"
This throws off my if Then statments because intead of it responding to 11 characters, it is now responding to 12.
What could be causing this problem
Dim strTest As String
Dim intByte As Integer, intChar As Integer
strTest = aupc.Text
intChar = Len(strTest)
MsgBox "Character Length = " & CStr(intChar) & vbCrLf & " ""Byte Length = " & CStr(intByte), , "StringLength rvBasic"
Set rsquery = cnwpm.Execute("Select * from master where upc = '" & aupc.Text & "'"
