Database results fields and cuurency value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get a $ currency formatted field to display in the DRW. The Access database being queried has the information formatted as cuurency but in the DRW it shows up with no curency sign or commas.
 
Youll need to remove the grey code from that cell too.
<%=FormatCurrency(Fp_Field(fp_rs,"YourField"))%>


mjg said:
How can I get a $ currency formatted field to display in the DRW. The
Click to expand...
Access database being queried has the information formatted as cuurency but
in the DRW it shows up with no curency sign or commas.
 
I have gone into HTML editor and made the changes but everytime I try to save them they get over written. How can I prevent that

----- dave wrote: ----

Youll need to remove the grey code from that cell too
<%=FormatCurrency(Fp_Field(fp_rs,"YourField"))%


mjg said:
How can I get a $ currency formatted field to display in the DRW. Th
Click to expand...
Access database being queried has the information formatted as cuurency bu
in the DRW it shows up with no curency sign or commas
 

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

Database Results Wizard and Record Advance Buttons 1
Database Column color format 2
Conditional formatting database results 7
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Globally Format Date 1
Database Results Wizard Error 4
DRW Question 1
Populating Email Subject Header 11

Back
Top