Displays numbers as $ on a form

's Computer Specifications

If a textbox is showing a value from a cell, can you format the textbox as
currency ($)... The cell has this formatting set to it, but it doesn't carry
over to the userform.
thanks.

's Computer Specifications

On Jan 3, 11:26*am, Southern at Heart
<SouthernatHe...@discussions.microsoft.com> wrote:
> If a textbox is showing a value from a cell, can you format the textbox as
> currency ($)... *The cell has this formatting set to it, but it doesn't carry
> over to the userform.
> thanks.

Try this

K = 50.449876 ' or a cell value
T.Value = Format(K, "0.00") & "$" 'TextBox

HTH
Joe

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
TOC displays seciton numbers - don't want them!	Access Joe	Microsoft Word Document Management	6	1st Sep 2008 09:20 AM
TOC Displays the Number 3 for all page numbers	=?Utf-8?B?TGFycnk=?=	Microsoft Word Document Management	15	31st Jul 2008 03:51 AM
Report displays numbers, not appropriate categories	Denniso6	Microsoft Access	10	7th Jul 2008 05:24 PM
I need a function that displays numbers as text	J.Alladien	Microsoft Access	1	17th Apr 2008 08:31 PM
Email Address Book Displays Fax Numbers	=?Utf-8?B?QnVkSw==?=	Microsoft Outlook Discussion	1	8th Feb 2005 03:47 PM