By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Text box in access report not displaying currency format

P: n/a
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!
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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!

Nov 13 '05 #2

P: n/a
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!

Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.