Hello All,
I have a table in my database with a field itemqty and the type was int and need to change it to decimal as i need the decimal point in my textbox.. i have a code for integer ascii values as bellow
i want to change this code and whtever i m doing my values is coming wrong coz i want both integer as well as decimal point ascii values.
can anyone help me in my code.
thank u in advance
 
	
							
						
					I have a table in my database with a field itemqty and the type was int and need to change it to decimal as i need the decimal point in my textbox.. i have a code for integer ascii values as bellow
i want to change this code and whtever i m doing my values is coming wrong coz i want both integer as well as decimal point ascii values.
can anyone help me in my code.
thank u in advance
Code:
	Private Sub txtItemQty_KeyPress(KeyAscii As Integer)
On Error GoTo ChkErr
If Chr(KeyAscii) Like "[!0-9]" And KeyAscii <> 8 Then
         KeyAscii = 0
    End If
Exit Sub
ChkErr:
    If Err.Number > 0 Then
    MsgBox Err.Number & vbNewLine & Err.Description
               Call ErrHand(Me.caption, "Form_Initialize")
        'Resume Next
    End If
End Sub