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

[Ali_1]

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

 

[fx3]

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