FP2000: How to Format Database Results as Currency (250465)

MORE INFORMATION

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

1. On a blank page in FrontPage, click the Insert menu, point to Database, and then click Results.
2. Click the button for the sample database connection (Northwind).
3. Click Next.
4. For the record source, click Products, and then click Next.
5. Click Edit List, and remove all Displayed Fields except for UnitPrice.
6. Click OK in the Displayed Fields dialog box, and then click Next twice.
7. Click Finish.
8. In Normal view in FrontPage, click the <<UnitPrice>> entry, and then click Delete.
9. With the insertion point still placed in the cell where the <<UnitPrice>> was deleted, switch to HTML view.
10. Insert the following code where the insertion point is positioned:

    <%=FormatCurrency(FP_FieldVal(fp_rs,"UnitPrice"))%>

11. Save the page as Currency.asp, and preview it in the browser. The UnitPrice is displayed in currency format.