FormatConditions

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
 

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


Top