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.field
notation) that field displays as though it's corrupt (symbols and the like)

Any ideas why this is the case?
Cheers,
Chris

[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.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

[Not Me]

"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