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!

Nov 13 '05 #1

Subscribe Reply

31970

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!

Nov 13 '05 #2

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!

Nov 13 '05 #3

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.

Nov 13 '05 #4

Similar topics

15470

Rounding, format(), fixed, differences between Access 97 and XP.

by: Mike MacSween | last post by:

This looks like a bug to me. I have an expression on a report: =Format(Sum((**)*(/)),"0.00") Score is byte PercentOfGrade is double PropDegree is single ModuleCats is byte

Microsoft Access / VBA

1416

Need help sending invoice data to a text box

by: Glenn Profitt | last post by:

Hi, I am using a text box as the subject for an invoice email. The textbox works fine for listing individual fields from the tblOrders table as shown below: ="Hi, " & & " " & "Your order is as follows:" & " " & " " & "Order ID: " & & " " & " Order Date: " & Format(,"Short Date") & " " & " Ship Via: " &

Microsoft Access / VBA

1658

E-Mail a formatted text attachment

by: brigitte | last post by:

Hi, I'm having trouble with a specific e-mail text format attachment ... The requirement is for the attachment to be .txt type and in this format: Label=FieldValue Label=FieldValue Label=FieldValue

Microsoft Access / VBA

3681

Exporting jet table metadata as text?

by: Kevin Chambers | last post by:

Hi all-- In an attempt to commit an Access MDB to a versioning system (subversion), I'm trying to figure out how to convert a jet table's metadata to text, a la SaveAsText. The end goal is to be able to build an MDB completely from the svn repository text files. Has anybody dealt with this? Thanks in advance,

Microsoft Access / VBA

3936

Access Hangs in Task Manager - Need Expert Help!

by: pic078 via AccessMonster.com | last post by:

I need serious help - I have a frontend/backend Access database (2 MDE Files) that remains stuck in task manager after exiting the application - you can't reopen database after exiting as a result - I have read every post out there and spent hours trying to figure out the problem with no success whatsoever - I have constrained the problem to one form however, and I think it's hiding somewhere in my code associated with this form, which is...

Microsoft Access / VBA

11060

Access 2007 Rich Text Deficiencies?

by: Neil | last post by:

I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in Access 2007 help seems to confirm the above. But that (or at least (b)) seems incredible that it...

Microsoft Access / VBA

3377

Listbox based on text box and combo box.

by: BerkshireGuy | last post by:

On an unbound form, I have a combobox called 'cboproducttype' and a text box called 'txtamountappliedfor'. I have an Add button that I would like the user to be able to hit once a product and amount applied for has been entered. This should populate an unbound listbox to display their selections. A user can select one or more sets of product types and the amount applied for. They should also have the functionality to remove a 'set' if...

Microsoft Access / VBA

1871

How to have access to the fields in the crystal report using VB.NET (outside the design of the crystal report) with SQL statements?

by: amiga500 | last post by:

Hello, I am developing a crystal report called Expense Report (I am not an expert Crystal Report designer) if someone could help me in this problem I would be greatly appreciate it. The report would be as follows: Description Sun Mon

.NET Framework

4273

Changing from text to currency and number error?

by: Brian | last post by:

Hello, I am new to Microsoft access 2007 and I have created a new database. There is a dollar about that I have to change from text to currency format. Also, there is a zip code that I have to change from text to number format. When I try to change them from text to either currency or number format I get an error stating "Some data may be lost" The setting for the FieldSize property of one or more fields have been changed to a shorter...

Microsoft Access / VBA

8240

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8175

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8680

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8336

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6111

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5565

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4177

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1791

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1487

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General