> I seem to remember cf having a nice lil function to format a form entry to convert it to dollars. was it dollarFormat? > basically, I need to make sure entries get inserted into the access db in the correct manner ($4,345.00) > I have tried to set the db to currency but when I do the insert quits working
As a matter of good practice, I wouldn't use DollarFormat() because you will be storing the dollar sign as well. Try using the NumberFormat() function, making sure to provide a format mask that matches the largest possible value you would expect from that field. As an example: Update myTable SET cost = #Trim(NumberFormat(form.myField, "999,999.99"))# WHERE id = 1 The Trim() function will remove any leading padding if the number passed in isn't as big as the mask provided. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
