View Single Post
  #2  
Old November 14th, 2005, 12:32 AM
Tom
external usenet poster
 
Posts: n/a
Default Question about a default table or method

You can set a default value for a field in the bottom part of the table
design view and this default value carries throughout the database
everywhere the field is used. You can also set the default value for a field
on a form and this default value will only be applied on that form. If you
set the default value in a table and want to use a different default value
on a particular form, set the default value also on the form and it will
override the table default value. The table default value will be applied on
all other forms.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

"Joe Cilinceon" wrote in message
...
What is the best way to have defaults in one location but available to the
whole application. Some examples would be Sales Tax rate, Late Fee charge
in addition to things like scanners/printers or other things used with in
the program.

--

Joe Cilinceon