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" <(E-Mail Removed)> wrote in message
news:6B9AB749-17B9-49CC-AB5D-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in messag
news:6B9AB749-17B9-49CC-AB5D-(E-Mail Removed)..
> 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

Make your changes in the gray code only and save your changes while you are
still in HTML view.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/




mjg <(E-Mail Removed)> wrote:
> 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" <(E-Mail Removed)> wrote in message
> news:6B9AB749-17B9-49CC-AB5D-(E-Mail Removed)...
> > 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.