Hey all,
I'm using a script to create a list of fields, based on checkboxes beside them. If the checkbox is checked, the corresponding price will be listed. I am using the following script example for each line:
+ Microsoft.VisualBasic.Interaction.IIf(GetCurrentColumnValue("IncludeEssentialsQuote")= -1 ,sNewLine + GetCurrentColumnValue("BasicPriceQuote").ToString(),"") _
As the field that is being entered is an interger, I have to convert it to a string (with .ToString). Now, my problem is I need the price displayed in a currency format, not a text or interger format.
I've spent the last 4 hours and dozens of different ways trying to get this to work, but nothing seems to do the trick. Any help would be GREATLY appreciated!
Thanks!