Text Box percentage problem

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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

I have a text box that shows 0.00% how can I make it so it is blank untill I
enter 12.5% or any fraction

Thanks in advance.........Bob Vance
 
Bob said:
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a text box that shows 0.00% how can I make it so it is blank untill
I enter 12.5% or any fraction
Click to expand...

Check the properties of the field in the table. There's likely a default
value of 0 there - just remove it.

For existing records, you'll need to run an update query to update existing
0 values to null.
 
Default Value Box is empty, I have used this before ;""; will something like
this work after the format, Thanks
 
Bob said:
Default Value Box is empty, I have used this before ;""; will something
like this work after the format, Thanks
Click to expand...

Also check the default value for the textbox control on your form.
 
Bob said:
Where do I find that, Thanks
Click to expand...

Open your form in design view. Select the textbox control that is bound to
your field. Go To View, Properties and then click on the Data tab. The
default property is listed there.
 
The default value is empty, thanks bob

Joan Wild said:
Open your form in design view. Select the textbox control that is bound
to your field. Go To View, Properties and then click on the Data tab.
The default property is listed there.
Click to expand...
 
Bob said:
The default value is empty, thanks bob
Click to expand...


I can't think of what else to try. If the default isn't showing in the
table, nor in the form.

Is your form based on a query? Does this show up in the query as well?

You are referring to 0.00 showing up on the new record, as opposed to
existing records, right?
 
When I open a new record I want to put in say 50%, but there is already 0.0%
and I want it to be blank, then I type 50 and it shows as 50%, Thanks Bob
 
Bob said:
When I open a new record I want to put in say 50%, but there is already
0.0% and I want it to be blank, then I type 50 and it shows as 50%, Thanks
Bob
Click to expand...

Again (sorry) are you doing this in a table, a query, a form?

If a form, what is the recordsource of the form (a table, a query, a sql
statement)?
 
Back
Top