Include numeric values in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've been trying to format a numering value in a control box to get a
nice printout but I can't get round to it.
This is what I want in a control box on my report:
="The amount due is " & [amount] &"."

The thing I can't solve is to use the currency format with a thousand
separator etc.

Thankyou for helping me.
Regards, Anders
 
Hi Anders-try this

="The amount due is " & FormatCurrency([amount]) & "."

Look in the Help screens under FormatCurrency for additional parameters.

Yours - Dika
 
Thanks for your help! /Anders

Kernow Girl said:
Hi Anders-try this

="The amount due is " & FormatCurrency([amount]) & "."

Look in the Help screens under FormatCurrency for additional parameters.

Yours - Dika
AE said:
Hi, I've been trying to format a numering value in a control box to get a
nice printout but I can't get round to it.
This is what I want in a control box on my report:
="The amount due is " & [amount] &"."

The thing I can't solve is to use the currency format with a thousand
separator etc.

Thankyou for helping me.
Regards, Anders
Click to expand...
Click to expand...
 
Back
Top