Access Field won't show as currency in the form, shows just a number (but works fine in the query)


Joined
Dec 13, 2020
Messages
1
Reaction score
0
I have created a query (query2) which looks up a value from another query (query1). The reason i used D lookup is so the form remains editable as the query in query1 is a sum.
When i run query2 it shows the dlookup (sum function in query1) as a currency (as it should). But when i display this in a form, it shows only as a number.
I have set the format of this (in both query and form) to currency, but it doesn't work.

I have attached a simplified version of my database showing the problem.
To get to the problem field, open DB, click on current projects, click on project 64 (skip & sing). The problem field is current facilitator spend (and current spend in other categories).
 

Attachments

  • test v02b 04 - simplified for forum.zip
    298.7 KB · Views: 41
Ad

Advertisements

fx3

Joined
Feb 17, 2013
Messages
13
Reaction score
0
Try not using dlookup - it's very slow, and less predictable
Instead look up the values by linking queries
I fixed your example file, see attached
 

Attachments

  • test v02b 04 - fixed.zip
    314.2 KB · Views: 19

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top