Divide by Zero Access Error 1

[perrdl]

I am using Microsoft Access 2000 to design a database in which data is entered into a form. I then perform calcutations on this data, but if zero is entered into a field I am trying to divide by, the result is populated with Error.

Is there any way that I can turn this off and simply poulate with zero, rather than producing an error message.

Thanks
Darren

 

[Databaseguy]

Populate the result with Zero if the text box that has the value that causes the error has a zero in it


Private Sub YourCommandButton on_click
If me.txtYourTextBox = 0 then
me.txtResult = 0
Else
me.txtResult = me.txtNumerator/me.txtYourTextBox
End Suv Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[ChrisBurch]

[somefield]=Iif([myfield]=0,0,mycalculation)

 

[perrdl]

This is exactly what I was after, ChrisBurch

Thanks a lot!!!
Daz

 

[ChrisBurch]

Daz,

For MS Access issues/queries you would be much better subscribing to the 'Microsoft: Access - General Discussion' forum.