Code for formula vs manual entry

  • Thread starter Thread starter Lori2836 via AccessMonster.com
  • Start date Start date
L

Lori2836 via AccessMonster.com

Good morning. Can someone help. I need to write code in a form where if
column 'A' is blank then allow manual entry into column 'C', else column 'A'
* 94.45. I'm not sure how to do this or if it can be done.

Thanks!
 
hi Lori,
Good morning. Can someone help. I need to write code in a form where if
column 'A' is blank then allow manual entry into column 'C', else column 'A'
* 94.45. I'm not sure how to do this or if it can be done.
Click to expand...
This needs some coding, place the following code into the On Change
events of the TextBoxes:

Private Sub txtA_Change()

If IsNumeric(txtA.Value) Then
txtC.Value = CDbl(txtA.Value) * 94.45
End If

End Sub


Private Sub txtC_Change()

txtA.Value = Null

End Sub


mfG
--> stefan <--
 
Thanks Stefan....but for some reason it doesn't work. When I type a number
into column 'A', nothing happens in column 'C'....it doesn't multiply by 94.
45.........
 
Back
Top