handling zero values

[lordnikon]

I have a text boxes that is updated based on a selection from a combo box. It updates several text boxes that contain prices, and some times that value is "$0.00." when i update that text box it doesn't put a value it in. It does if the value is anything but zero. I put the default value to zero and it fills it in with $0.00 when i open the form but when I update that value, it clears it out. Any help on how i can get these text boxes to insert the value $0.00?

Here is what my code looks like? Is it possible that my data from the combo box is screwing it up?

Private Sub Combo57_AfterUpdate()

[Original Price] = Combo57.Column(1) --these are supposed to be the same value

[Material Surcharge] = Combo57.Column(1) --these are supposed to be the same value

[Heat Treat Surcharge] = Combo57.Column(2)

[Frieght Surcharge] = Combo57.Column(3)

[Packaging Surcharge] = Combo57.Column(4)

[Other Surcharge] = Combo57.Column(5)

[Total Surcharge] = [Original Price] + [Material Surcharge] + [Heat Treat Surcharge] + [Frieght Surcharge] + [Packaging Surcharge] + [Other Surcharge]

End Sub

i think that there is something wrong with my combo box

i have the data to fill the combo box coming from a query that lists all of the data that i want on the form. When I click on the drop down button for the combo box there isn't formatting on anything. Like currency appears like 3.75 instead of $3.75. Is this a problem when it comes to handling zero values? is there some way that this formatting problem is effecting the zeros?


http://www.access-programmers.co.uk/forums/editpost.php?do=editpost&p=719346

 

[RuralGuy]

I suspect you are dealing with a Null. Try using the Nz() function.

 

[missinglinq]

He was told this yesterday, on this very forum!

http://www.access-programmers.co.uk/forums/showthread.php?t=151949

 

[RuralGuy]

Hi Linq,
Hmmm...LordNikon, are you having trouble using the Nz() function? It looks like Linq explained it pretty well in that other thread.