Default Value Not Showing In Form

[Kenny G]

Hello

I have put in a control source RiskAssessmen
the default value of "N" and a Validation Rule "Y" or "N"

The trouble is the default value never shows up when I open the form. Any ideas?

Thanks, Kenny G

 

[Steve Schapel]

Kenny,

The Default Value property only applies to new records, not existing
records... is that what you are referring to? And RiskAssessment would
need to be a Text data type... is that what you've got?

 

[Kenny G]

Steve

The RiskAssessment is a text box.

I have five fields that have the default fields in them.

When the first form over the main table is opened all default values show up and data can be changed based on if the fields are disabled.

The second form is opened over the main table to complete the record. At that time the fields that were not completed (these five fields with defaults) can be changed or left to remain at their default values

The only field that does not have the default value visible is the RiskAssessment - and yes the visible value is yes

Thanks for your help

Kenny G

 

[Steve Schapel]

Kenny,

Are your Default Values set for the fields in the design of the table,
or are they set for the controls in the design of the form, or perhaps
both? And, just to repeat my earlier question... Is RiskAssessment a
Text data type?

 

[Russ]

If you use a text control instead of a Yes/No it should work as you
describe. What data type have you set for it?

Russ