Lost currency format

[Dorothy]

I have a field [AmtFunded]that is formatted for currency
and auto decimal places. When I put this field on a form
by itself it is formatted properly ($2,399.11.), but when
I combine it so that a 'period' would be at the end of it
(it's the end of a sentence)I don't get the '$' So I had
to create this code =("$" & [AmtFunded] & ".")
but now I don't get the comma after the thousand number.
My question is 2 part: 1) why wouldn't the format stay
when concatenating to place a "."? 2)How can I get the
comma to show?

 

[Allen Browne]

When the Control Source of your text box is a Currency type field, Access
uses the Currency type format.

When you change the Control Source into an expression that contatenates 2
things, the result is a piece of text, not a currency field. As a result,
Access does not automatically format it for you.

Use the Format() function to specify how you want it formatted in your
string expression, e.g.:
=Format([AmountFunded], "Currency") & "."

 

[Dorothy]

Thank you. Worked great.

-----Original Message-----
When the Control Source of your text box is a Currency type field, Access
uses the Currency type format.

When you change the Control Source into an expression that contatenates 2
things, the result is a piece of text, not a currency field. As a result,
Access does not automatically format it for you.

Use the Format() function to specify how you want it formatted in your
string expression, e.g.:
=Format([AmountFunded], "Currency") & "."

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a field [AmtFunded]that is formatted for currency
and auto decimal places. When I put this field on a form
by itself it is formatted properly ($2,399.11.), but when
I combine it so that a 'period' would be at the end of it
(it's the end of a sentence)I don't get the '$' So I had
to create this code =("$" & [AmtFunded] & ".")
but now I don't get the comma after the thousand number.
My question is 2 part: 1) why wouldn't the format stay
when concatenating to place a "."? 2)How can I get the
comma to show?

.