Text Box percentage problem

[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

 

[Joan Wild]

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

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.

 

[Bob]

Default Value Box is empty, I have used this before ;""; will something like
this work after the format, Thanks

 

[Joan Wild]

Default Value Box is empty, I have used this before ;""; will something
like this work after the format, Thanks

Also check the default value for the textbox control on your form.

 

[Bob]

Where do I find that, Thanks

Also check the default value for the textbox control on your form.

 

[Joan Wild]

Where do I find that, Thanks

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.

 

[Bob]

The default value is empty, thanks bob

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.

 

[Joan Wild]

The default value is empty, thanks bob

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?

 

[Bob]

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

 

[Joan Wild]

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

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)?