Concatenate number w/decimal with ascii character

  • Thread starter Thread starter ShoeHo65
  • Start date Start date
S

ShoeHo65

I need to concatenate a standard format number (ie 1,2345.00) with an
ascii character (ie foreign currency); however, when I do, I lose the
comma(s) as well as the numbers to the right of the decimal. Is there
a way around this?
 
I need to concatenate a standard format number (ie 1,2345.00) with an
ascii character (ie foreign currency); however, when I do, I lose the
comma(s) as well as the numbers to the right of the decimal. Is there
a way around this?
Click to expand...


Use the Format function instead of the text box's Format
property. R.g. the text box's expression might be:

= currenychar & Format(amount, Currency)
 
Use the Format function instead of the text box's Format
property.  R.g. the text box's expression might be:

= currenychar & Format(amount, Currency)
Click to expand...

That's exactly what I needed which means I should practice what I
preach - Keep It Simple Stupid! THANK YOU!!!
 
Back
Top