How to represent Currency in textbox on VB Form

Posted by David Holstein on October 18, 1999 5:50 AM

I have a number of text boxes on a form that I need represented in $0.00 format. I can get the value into the textbox by the Control Source, but am yet to figure out how to change the format.

Much appreciated if anybody can help

Thankyou
David

Posted by Chris on October 18, 1999 9:42 AM

David,

This should help:

UserForm1.TextBox1.Value = Format(whatever, "$0.00")

You can replace "whatever" with the value you wish to input to the text box.

HTH,
Chris