Can you do record validation in Datasheet view? 1

[vpellerito]

Is there a way to code simple validation when viewing a form as a datasheet?
I have Field1 that is Yes/No. I don't want Field2 to allow data entry unless Field1 = Yes.

If Field1 = "Yes" Then
   Field2.Enabled = True
Else
   Field2.Enabled = False
End if

This code disables all the records for Field2 when I view the form as a datasheet... I don't want that. I want specific records to be enabled/not enabled.

Is this possible in datasheet view?
Thanks,
Vince

 

[Remou]

Have a look at Conditional Formatting.

 

[PWise]

try this
add on form current

Field2.Enabled=Field1 = "Yes"

 

[Remou]

pwise, I think you may have missed vpellerito's mention of a datasheet?

 

[PWise]

viewing a form as a datasheet

 

[Remou]

... Which means that any property set for a control will be applied to all records, unless conditional formatting is used. YesNo?

 

[vpellerito]

The datasheet view won't allow me to validate on one specific record using the code I entered above. The Conditional Format in the menu options doesn't seem to allow me to reformat Field2 based on the value of Field1.

I think I remember more flexibility for Conditional Format using VB but I'll have to look into that.

Thanks,
Vince

 

[Remou]

You can use an Expression.

 

[vpellerito]

Of course. Thanks Remou. That was easier than I thought.
Vince