Hi, I tried that
Code:
Me.lstProjectDetails.AddItem "Change Awarded;" & Format(rstqryAssignmentDetails.Fields("AmountAwarded"), "£0,000.00")
It came up with just a two number format £67, when it should be £67,000.00
Did I code it right?
Thanks
Marc
Originally Posted by
Lupson2011
Hi all,
I am writing some code where I am displaying certain information in a list dependent on a choice from a combo box.
It all works fine, but a couple of the fields are currency format and I wondered if there was anything easy I could add to the line of code below which wold ensure that it is displayed in currency and not just number, or do I have to different lines of code for this?
Code:
Me.lstProjectDetails.AddItem "Change Awarded;" & rstqryAssignmentDetails.Fields("AmountAwarded")
thanks
marc