No Money

  • Thread starter Thread starter rob p
  • Start date Start date
R

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...
 
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
________________________
 
thanks Gary. works fine.
rob

Gary Miller said:
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 said:
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...
Click to expand...
Click to expand...
 
Back
Top