Database results fields and cuurency value?

M

mjg

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.
 
D

dave

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
Access database being queried has the information formatted as cuurency but
in the DRW it shows up with no curency sign or commas.
 
M

mjg

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
Access database being queried has the information formatted as cuurency bu
in the DRW it shows up with no curency sign or commas
 
Top