N
Norbert Meiss
I try to set conditional formatting for a control in a continous form with
the following VBA code (Access 2007):
With Me
With .ADD_Status
.FormatConditions.Delete
.FormatConditions.Add acExpression, , "ADD_Status = 0"
.FormatConditions.Add acExpression, , "ADD_Status = 1"
.FormatConditions.Add acExpression, , "ADD_Status = 2"
.FormatConditions.Add acExpression, , "ADD_Status = 3"
.FormatConditions.Add acExpression, , "ADD_Status = 4"
....
In the last line shown I get the error 7966. I thought, conditional
formatting ist not limited to 3 or 4 when using VBA code. What is going wrong?
TIA, Norbert
the following VBA code (Access 2007):
With Me
With .ADD_Status
.FormatConditions.Delete
.FormatConditions.Add acExpression, , "ADD_Status = 0"
.FormatConditions.Add acExpression, , "ADD_Status = 1"
.FormatConditions.Add acExpression, , "ADD_Status = 2"
.FormatConditions.Add acExpression, , "ADD_Status = 3"
.FormatConditions.Add acExpression, , "ADD_Status = 4"
....
In the last line shown I get the error 7966. I thought, conditional
formatting ist not limited to 3 or 4 when using VBA code. What is going wrong?
TIA, Norbert