Text Box format question

  • Thread starter Thread starter Bob
  • Start date Start date
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
 
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>
 
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
 
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>
 
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
 
Back
Top