468,774 Members | 2,614 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,774 developers. It's quick & easy.

No decimal currency format

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

Similar topics

2 posts views Thread by Dalan | last post: by
2 posts views Thread by DD | last post: by
2 posts views Thread by Bob Dydd | last post: by
3 posts views Thread by Claudia Fong | last post: by
2 posts views Thread by Ian | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.