Numbers To Words

[Derrick T. Davidson]

Hi Back again, can you tell me how to modify the above code to show 0 = "Zero"

[June7]

You want to return "Zero" if the input value is 0?

Add an Else to the outermost If Then.

The last 8 lines will become:

Next intCounter
End If
End If
Else
strText = "ZERO"
End If
NumWord = strText
End Function

[Derrick T. Davidson]

When I added the box that should show number in words is blank, it doesn't say there is any error in the code???

[Derrick T. Davidson]

Now it works ???????

[June7]

Added box where - on form?

Working?

The code won't handle Null.