No Money

[rob p]

I am using the convert currency to english module in a report. If I have no
amount I get error on the line "MyNumber = Trim(Str(MyNumber)

The text box field has "Convert Currency to English(txtamount)

where txtamount's control source is
=Format(Sum([tbldetail].[Amount]),"#,###.00") and format is set to standard
and decimal places are 2.

It works if I have an amount. Should I test somewhere to see if txtamount is
null?
Thanks...

 

[Gary Miller]

Rob,

Use the Nz() function to turn your null amount into a zero.
Not familiar with your function, but if it is properly
written, it should not bomb on a zero...

Convert Currency to English(Nz([txtamount],0)


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[rob p]

thanks Gary. works fine.
rob

Rob,

Use the Nz() function to turn your null amount into a zero.
Not familiar with your function, but if it is properly
written, it should not bomb on a zero...

Convert Currency to English(Nz([txtamount],0)


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

I am using the convert currency to english module in a report. If I have no
amount I get error on the line "MyNumber = Trim(Str(MyNumber)

The text box field has "Convert Currency to English(txtamount)

where txtamount's control source is
=Format(Sum([tbldetail].[Amount]),"#,###.00") and format is set to standard
and decimal places are 2.

It works if I have an amount. Should I test somewhere to see if txtamount is
null?
Thanks...