Text Box format question

B

Bob

$#,##0.00;($#,##0.00);""
I have this in my textbox Format but I am still getting a 0 in my box and if
I enter 12 in front of the zero I get $120.00 instead of $12.00

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

Jeff Boyce

Bob

"I am ... getting a 0 in my box."

We're not there, so we can't see which box, and whether this is on a form or
a report or a table, or ...?

Do you have a default value set on this field? Is it "0", perchance?

If you "enter 12 in front of the zero", isn't that "120"?

Good luck

Jeff Boyce
<Access MVP>
 
B

Bob

Sorry it is on a Form and the box is empty till I click in it then a zero
appears, Default Option in properties is Blank, Thanks Bob
 
J

Jeff Boyce

Bob

Forms are usually based on queries or tables. Controls (e.g., textboxes)
are based on fields. Is this textbox based on a field? What is the
datatype of the underlying field? Does the table definition of this field
include a default?

Is there any behind the form? If the textbox is empty until you click in
it, it sounds like some code is running.

Jeff Boyce
<Access MVP>
 
B

Bob

Yes you are right, Its the cost box of expenses so if I type Choc in one box
I get Chocolates in another and the text box that I refer to either has a
set price or left blank for me to enter a price , that's when I get the zero
when I click in it, Thanks Bob
 
Top