Field won't let me change format

[Tommo]

I have a query in which I have used a dSum to generate a total amount from multiple payments. For some reason in the properties I cannot change the format. It has a drop down but it is blank. Also how can I get all the empty cells to show £0.00?

Thanks

[LaughingBull]

Check this out I think it will answer your question https://support.microsoft.com/en-us/kb/290136

[June7]

Why do this formatting in query? Do it in textbox on form or report.