Currency field corrupt display in query..

Not Me

Hi,

I have a table with a currency field, which is displayed via a form. If I
open a query which displays this field (using the forms!myform.fi eld
notation) that field displays as though it's corrupt (symbols and the like)

Any ideas why this is the case?
Cheers,
Chris

Nov 12 '05 #1

Subscribe Reply

1880

Allen Browne

The symptoms indicate that Access has misunderstood the data type in the
query.

To avoid that, declare your parameter so Access knows its type:

1. In query design view, copy the reference - [Forms]![MyForm]![MyField]

2. Choose Parameters from the Query menu. Access opens a dialog.

3. Paste the reference into the first column, and in the 2nd column choose
Currency.

There are other things you can do as well. See:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Not Me" <No****@faker.f ake.fa.kee> wrote in message
news:c6******** **@ucsnew1.ncl. ac.uk...

I have a table with a currency field, which is displayed via a form. If I
open a query which displays this field (using the forms!myform.fi eld
notation) that field displays as though it's corrupt (symbols and the like)
Any ideas why this is the case?
Cheers,
Chris

Nov 12 '05 #2

Not Me

"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:40******** *************** @freenews.iinet .net.au...

The symptoms indicate that Access has misunderstood the data type in the
query.

To avoid that, declare your parameter so Access knows its type:

1. In query design view, copy the reference - [Forms]![MyForm]![MyField]

2. Choose Parameters from the Query menu. Access opens a dialog.

3. Paste the reference into the first column, and in the 2nd column choose
Currency.

There are other things you can do as well. See:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

Looks great, Cheers

Chris

Nov 12 '05 #3

Similar topics

12284

double to currency and currency to double

by: Brandon McCombs | last post by:

hello, I have an app that pops up a custom dialog box and one of the fields for user input is an account balance field. The data gets put into an Object and eventually into an instance of DefaultListModel. When I use getText() on the field I pass it to Double.parseDouble to convert it so I can store it as a number and not a string. When I display it (either in the list or in the dialog box) I want it to be displayed using currency...

Java

9599

Currency Format Blues

by: Dalan | last post by:

This should not be an issue, but it is. I'm sure that someone knows what little piece of code is needed too persuade Access 97 to include a currency format for labels (Avery, mailing type). Have had no problems with currency formatting on reports - just the labels. Doesn't matter if the associated field in the Table and Form have Format as Currency, because on the labels (for instance $50.00) prints as: 50 The only way to get it to print...

Microsoft Access / VBA

13409

No $ for Currency fields

by: Melissa | last post by:

I have several fields in my database specified as Currency data type. Is there a way globally to set these fields not to display the dollar sign? Thanks! Melissa

Microsoft Access / VBA

2225

UnionQry Currency format

by: DD | last post by:

I have a UnionQry that is run from StatementsI and StatementP. the Due and Paid colunms are currency and show the $ however when i union the two the currency format has gone. Any help please SELECT * FROM qryStatementI UNION SELECT * FROM qryStatementP ORDER BY thedate;

Microsoft Access / VBA

366

Currency field corrupt display in query..

by: Not Me | last post by:

Hi, I have a table with a currency field, which is displayed via a form. If I open a query which displays this field (using the forms!myform.field notation) that field displays as though it's corrupt (symbols and the like) Any ideas why this is the case? Cheers, Chris

Microsoft Access / VBA

3809

Getting currency to appear in mail merge from fields made in query

by: Tom Keane | last post by:

Hi, I need some helpings again! I have a query from one of my tables that gets a total amount of money and gets a percentage from it ie, the field I create in the query is invGSTAmount from a field in my table called invAmount, so I but in the design view of my query: invGSTAmount: *1/11

Microsoft Access / VBA

1145

Currency Formatting

by: jereesh | last post by:

Hi, I need to display formatted currency values in the My UI currency fields. I would like to know how to do currency formating in javascript . ie when I pass the value and the currency code it should display the formatted currency in the field with currency symbol. the Code will be like USD, EURO etc. but when it get displayed it should display the curresponding sysmbol can any body help me in this Regard Regards

Javascript

3940

Currency field with 2 decimal

by: dhanashri | last post by:

I need to display the data in the currency field up to 2 decimal point. example if the fetch from data base is option 1: 12.547 want to display 12.55 option 2: 12 want to display 12.00 option 3: 12.5 want to display 12.50 is there is any way I can use any oracle function and make my sql query result look like this. I will really appreciate help.

Oracle Database

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

8234

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

8172

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

8620

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8335

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

8474

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6110

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

4079

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4174

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

1784

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