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" <Not.Me@faker.fake.fa.kee> wrote in message
news:c6aub8$m0k$1@ucsnew1.ncl.ac.uk...[color=blue]
>
> 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[/color]
like)[color=blue]
>
> Any ideas why this is the case?
> Cheers,
> Chris[/color]
