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

No decimal currency format

P: n/a
Hi All.

How can i put a zero decimal for my currency into my format statement,

==[StartDate] & ", for " & [duration] & " days. Cost " &
Format([crsinscost],"Currency")
which is the data source for a textbox on a report

Thanks

Gerry Abbott


Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Format([crsinscost],"$#,##0;($#,##0)")

On Tue, 16 Nov 2004 14:59:01 -0000, "Gerry Abbott" <pl****@ask.ie> wrote:
Hi All.

How can i put a zero decimal for my currency into my format statement,

==[StartDate] & ", for " & [duration] & " days. Cost " &
Format([crsinscost],"Currency")
which is the data source for a textbox on a report

Thanks

Gerry Abbott


Nov 13 '05 #2

P: n/a
You want to display whole dollars only. No cents. Ignore negatives?

=[StartDate] & ", for " & [duration] & " days. Cost " &
Format([crsinscost],"$#,##0")

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

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:DA*******************@news.indigo.ie...
Hi All.

How can i put a zero decimal for my currency into my format statement,

==[StartDate] & ", for " & [duration] & " days. Cost " &
Format([crsinscost],"Currency")
which is the data source for a textbox on a report

Thanks

Gerry Abbott

Nov 13 '05 #3

P: n/a
Thanks, Allen,
this format uses a specific character for the currency.
1.Is there a way to use the system currency symbol here.
2.Is there a good reaource to expain the formatting

Gerry Abbott

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
You want to display whole dollars only. No cents. Ignore negatives?

=[StartDate] & ", for " & [duration] & " days. Cost " &
Format([crsinscost],"$#,##0")

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

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:DA*******************@news.indigo.ie...
Hi All.

How can i put a zero decimal for my currency into my format statement,

==[StartDate] & ", for " & [duration] & " days. Cost " &
Format([crsinscost],"Currency")
which is the data source for a textbox on a report

Thanks

Gerry Abbott


Nov 13 '05 #4

P: n/a
Hi Gerry. It's easy enough to use your own currency symbol in the formatting
string.

To get help on Format():
- Open the Immediate Windows (Ctrl+G).
- Type: Format(
- Move the cursor back into the word.
- Press F1
- When the Help window opens, chose the one about number formatting.

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

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:zP*******************@news.indigo.ie...
Thanks, Allen,
this format uses a specific character for the currency.
1.Is there a way to use the system currency symbol here.
2.Is there a good reaource to expain the formatting

Gerry Abbott

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
You want to display whole dollars only. No cents. Ignore negatives?

=[StartDate] & ", for " & [duration] & " days. Cost " &
Format([crsinscost],"$#,##0")
"Gerry Abbott" <pl****@ask.ie> wrote in message
news:DA*******************@news.indigo.ie...
Hi All.

How can i put a zero decimal for my currency into my format statement,

==[StartDate] & ", for " & [duration] & " days. Cost " &
Format([crsinscost],"Currency")
which is the data source for a textbox on a report

Thanks

Gerry Abbott

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.