Text box in access report not displaying currency format

[Scott Gorman]

I have created a report in access. I had to add a text box to input a
value for previous months balance. I have formatted to display with $
currency, and also with the " , " for thousand separator.
I have not been able to get it to display correctly. It is just the
numbers without the formatting.
Please help !!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ed Robichaud]

Sounds like you tried a custom format (for the text box) that's not working.
Access has a currency format that you can select in the control properties.
Is the control source for your textbox a number field? If not, you'll be
much better off changing the bound field to a number type.
-Ed

"Scott Gorman" <sg***@comcast.net> wrote in message
news:41**********@127.0.0.1...

I have created a report in access. I had to add a text box to input a
value for previous months balance. I have formatted to display with $
currency, and also with the " , " for thousand separator.
I have not been able to get it to display correctly. It is just the
numbers without the formatting.
Please help !!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Michael \(michka\) Kaplan [MS]]

Did you put the format into the report's TextBox, itself?
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure, Fonts, and Tools
Microsoft Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Scott Gorman" <sg***@comcast.net> wrote in message
news:41**********@127.0.0.1...

I have created a report in access. I had to add a text box to input a
value for previous months balance. I have formatted to display with $
currency, and also with the " , " for thousand separator.
I have not been able to get it to display correctly. It is just the
numbers without the formatting.
Please help !!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[fredg]

On 29 Jan 2005 19:00:11 -0600, Scott Gorman wrote:

I have created a report in access. I had to add a text box to input a
value for previous months balance. I have formatted to display with $
currency, and also with the " , " for thousand separator.
I have not been able to get it to display correctly. It is just the
numbers without the formatting.
Please help !!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Either set the control source to:
1) =Format([FieldName],"currency")
or..
2) =Format([FieldName],"$#,###.00")
or...
Set the Format property to the control to:
3) currency
or...
Set the Format property of the control to:
4) $#,###.00;-$#,###.00;$0.00

One of the above should do it.

Next time I suggest you actually post the control source rather than
just trying to tell us about it.

If you are using an expression with text to display in the
control,i.e. ="Amount owed " & [FieldName], you must use #1 or #2.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.