Blank Text Box!

[Bob]

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a text box that you enter in payments, is it possible for this text
box to be blank, at the moment it shows $0.00 can I make it blank so if I
enter 123.23 it will show $123.23


Thanks in advance.........Bob Vance

 

[Guest]

You should be able to set it to null and get nothing. For example, default
value "Null."

The $ is a currency format.

 

[Ken Snell [MVP]]

You can use the Format property of the textbox to change the display:

$#,##0.00;-$#,##0.00;"";""

In this case, if a zero is in the textbox, the display when the textbox
doesn't have the focus will be "empty".

 

[Bob]

BRILLIANT Thanx I changed it slightly to this , is that OK?
$#,##0.00;($#,##0.00);"";""
TIA Bob

 

[Ken Snell [MVP]]

That's fine!

--

Ken Snell
<MS ACCESS MVP>

BRILLIANT Thanx I changed it slightly to this , is that OK?
$#,##0.00;($#,##0.00);"";""
TIA Bob