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

Currency field corrupt display in query..

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


P: n/a
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.fake.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.field
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

P: n/a
"Allen Browne" <Al*********@SeeSig.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

This discussion thread is closed

Replies have been disabled for this discussion.