Re: passing number formatting to documents and email

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • DeZZar

    Re: passing number formatting to documents and email

    where would I add that in?

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

    the reference to Forms!frm_Lease locks!Amount is where the currency
    amount is held. how do I tell it to read the format as well?
  • DeZZar

    #2
    Re: passing number formatting to documents and email

    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!
    frm_Leaselocks!
    Amount, "Currency") &_

    Cheers!!!

    Comment

    Working...