Text box will not show Currency when no information is in text box

  • Thread starter Thread starter Russ via AccessMonster.com
  • Start date Start date
R

Russ via AccessMonster.com

I have the following code in a text box;
=DSum("[PaymentAmount]","tblOrderPayments","[OrderID] = Forms![frmOrders]!
OrderID")
text box is set to currency, but will not show $0.00 when no information is
in the text box.
Any suggestions?
 
try this....... =nz(DSum("[PaymentAmount]","tblOrderPayments","[OrderID] =
Forms![frmOrders]!OrderID"))*1

NZ is a function that replaces null values to zero...

zaqyu
 
Wow, tried everything but the *1 at the end, that did the trick. But WHY?
try this....... =nz(DSum("[PaymentAmount]","tblOrderPayments","[OrderID] =
Forms![frmOrders]!OrderID"))*1

NZ is a function that replaces null values to zero...

zaqyu
I have the following code in a text box;
=DSum("[PaymentAmount]","tblOrderPayments","[OrderID] = Forms![frmOrders]!
OrderID")
text box is set to currency, but will not show $0.00 when no information is
in the text box.
Any suggestions?
Click to expand...
Click to expand...
 
thanks zaqyu
try this....... =nz(DSum("[PaymentAmount]","tblOrderPayments","[OrderID] =
Forms![frmOrders]!OrderID"))*1

NZ is a function that replaces null values to zero...

zaqyu
I have the following code in a text box;
=DSum("[PaymentAmount]","tblOrderPayments","[OrderID] = Forms![frmOrders]!
OrderID")
text box is set to currency, but will not show $0.00 when no information is
in the text box.
Any suggestions?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

check box to update text box 10
Data Type in table shows currency but on form it shows as Text Box. 2
Currency is Not working 8
Order form 2
adding using recordset does not include linked field of subform 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
text box select text 1
Combobox Not In List 2

Back
Top