Property of a text box

mrowe · May 21st, 2002, 04:43 AM

Can I assign a currency property to a text box on a user form?

If so, how...

Thanks
Matt

Ivan F Moala · May 21st, 2002, 06:06 AM

Quote:

On 2002-05-21 03:43, mrowe wrote:
Can I assign a currency property to a text box on a user form?

If so, how...

Thanks
Matt

NO. There is no property of a textbox for this. What you have to do is Format the Textbox Text as currency. eg.

TextBox1.Text = Format(TextBox1.Text, "$###,###.##")

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 04:43 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Can I assign a currency property to a text box on a user form? If so, how... Thanks Matt