Forms not Displaying Default Value

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

Guest

In my database I have several forms that require a default value to be shown,
this default value is bound to a field, either Date or Shift. There is one
form I've got where the default value is only shown if the text box it is in
is unbound. This has not been a problem in the other twelve forms I've got,
what am I doing wrong here?

Thanks for the help

Tommy
 
Tommy

Just to be clear, forms in Access don't hold data, they offer a view through
to an underlying table (perhaps via a query). If you have a default value
set on a form, unless you have a new record (to which that default would
apply), you don't actually have the default value. Old records
(pre-existing) don't count. They already have values in those fields for
which you've established "defaults".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 

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

How to change Default Value on Form 3
Default Values in Unbounded form 5
Default Value on Continuous Form 2
Default Value on Form Help 1
Default text box as query filter 4
Do Not Display Default Value 8
how to set the Default Value of a Control Box to a Lookup Table 0
default value from another table 1

Back
Top