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

Re: passing number formatting to documents and email

P: n/a
where would I add that in?

For example the line:
vbNewLine & "Drawdown Amount:" & " $" & Forms!frm_Leaselocks!

the reference to Forms!frm_Leaselocks!Amount is where the currency
amount is held. how do I tell it to read the format as well?
Nov 13 '08 #1
Share this Question
Share on Google+
1 Reply

P: n/a
hold that - I figured it out!!

Thanks again Salad. I love how you provide 'tips' without the exact
answer! Gives me a chance to figure it out!

vbNewLine & "Drawdown Amount:" & " " & Format(Forms!
Amount, "Currency") &_

Nov 13 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.