Blank field until selected

T

Todd

I have a currency field and a number field that I would
like to be blank until data is entered into them. How can
I get this to happen? I have tried using = "" in the
default value, but as soon as the primary field has data
entered in these fields populate with a 0. Thanks for the
help.
 
T

tina

sounds like the default value of those fields in the underlying table is set
to zero. Access does this automatically when you add a number field to a
table, unfortunately. open the table in design view and check those fields'
Default Value property.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top