hello,

  I am using Microsoft Access, and trying to creating one FORM, now what i want to do is, when i suppose to enter data in row, after pressing TAB (to move next column), the entered data shoudl multilplied by 0.001 and replace there itself when i first enter data..

  Any ideas, tell me in brief, am new to EXCEL..

~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~

~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~

__________________
~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~

If I understand the question correctly...

Put this in the worksheet..

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Application.OnKey "{TAB}", "IncrementNum"
End Sub

And this in a module..

Public Sub IncrementNum()
    myRow = ActiveCell.Row
    myCol = ActiveCell.Column
    If myCol = 1 Then Exit Sub
    Cells(myRow, myCol).Value = Cells(myRow, myCol).Value * 0.001
    Cells(myRow, myCol + 1).Select
End Sub