Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-22-2014, 05:10 AM   #1
kmortara
Newly Registered User
 
Join Date: Jul 2014
Posts: 1
Thanks: 1
Thanked 0 Times in 0 Posts
kmortara is on a distinguished road
Default value propagation in forms

I have a simple bound form with a series of yes/no fields. When I type (or select) a value in the first field, the rest of the fields take on default vaules - in this case "No". I have removed the default from the table definition, and from the form, although originally both showed default "0" (zero).

Is this behavior because I originally had the default set and the form was created with that information? Is there any way I can stop the default values from appearing in the form fields?

kmortara is offline   Reply With Quote
Old 07-22-2014, 05:22 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,224
Thanks: 40
Thanked 3,641 Times in 3,512 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Default value propagation in forms

Quote:
Is this behavior because I originally had the default set and the form was created with that information?
Yes

Quote:
Is there any way I can stop the default values from appearing in the form fields?
No - but you can set the default value to 'blank' in the field design. Or you can create an unbound control, and then assign the field to its control source
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
kmortara (07-22-2014)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Regarding défault values in Sub forms Trisha2014 Queries 5 03-11-2014 07:05 AM
default no. and forms colenzo Forms 3 02-18-2011 08:16 AM
Default value in forms SueBK Forms 7 05-20-2009 03:47 PM
Propagation of values to subsequent years Tony1258 Modules & VBA 0 06-12-2006 10:28 AM
Propagation of values to subsequent years Tony1258 Modules & VBA 0 06-12-2006 10:25 AM




All times are GMT -8. The time now is 12:15 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World