0

I'm a database guy more than a Programmer, so bear with me. I'm creating a receipt form for a point of sales software, and ran into an issue with formatting my numbers. In the number section of the textbox properties it's formatted to add a comma to any amount over a thousand (the values passed from the data set are Decimal(15,2))

When I print the number on it's own, it's formatted fine. When I add a $ to the beginning through the textbox properties, the commas go away. I assume it's because the number is converted to a string to be concatenated with the $

What I'd like to be able to do is have both the dollar sign, and the number with a comma in one text box. I believe it can be done with an if/else to determine string length, then substringing out the amount and adding commas in the code, but that seems excessively bulky.

Here's the code that prints $1000.00 instead of $1,000.00:

="$" & First(Fields!AMOUNT.Value, "DsSalesTicketReport")
ThexTallxDude
  • 137
  • 1
  • 1
  • 11

1 Answers1

1

For formatting a number as currency (per the system's locale) VBScript provides the FormatCurrency() function. The result will still be a string, though, so only use this if you don't need to do any calculations with the number.

Ansgar Wiechers
  • 193,178
  • 25
  • 254
  • 328
  • Yeah, I was going to add the commas in the SP that the dataset calls from, but I would have run into an issue doing calculations on other parts of my form. this solution works wonderfully for what I needed, thank you. – ThexTallxDude Jan 24 '19 at 19:49