By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,106 Members | 2,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,106 IT Pros & Developers. It's quick & easy.

DSum Formatting Issues

P: n/a
This seems a bit odd, but I have not been able to persuade Access 97
to format several DSum total columns in Currency - Standard format. It
appears to be defaulting to a general number format instead. The text
box format is set to standard and so is the related query properties
supplying the totals.

Does anyone have any ideas as to a workaround for this issue?

Thanks, Dalan
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You could set your controlsource to something like this:
=Format(DSum(...),"currency")

HTH
- Turtle

"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om...
This seems a bit odd, but I have not been able to persuade Access 97
to format several DSum total columns in Currency - Standard format. It
appears to be defaulting to a general number format instead. The text
box format is set to standard and so is the related query properties
supplying the totals.

Does anyone have any ideas as to a workaround for this issue?

Thanks, Dalan

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.