Changing global default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many Number Colums, where the Default Value is always set to 0. I
normally want no Default Value for Number Fields. Is it possible to have no
Default Value as a Standard for Number Fields?

Thanks
 
Good question. If you are defining your tables via the
interactive mode using the design view of a table, I know of
no way -- you have to manually delete the DefaultValue.

Normally, what I do is make one field and then copy that
down, changing the fieldname and description, for the data
types that are the same.

Tables can be defined using code -- then you can make the
default value whatever you want.

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
You must log in or register to reply here.

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

Similar Threads

Default number format in Excel 1
change default value in table field - Easy for user 4
Auto number in an existing table 4
Sub Form Default Values 4
How I can access and change global address list option of schedule management? 0
Default Value as last date in a table? 5
How to add 1 (one) to the default value 2
Formatting a percent field 1

Back
Top