Help w/Conditional Formatting Code

T

TotallyConfused

I have used up my conditional formatting options in Conditional Formatting.
I am trying to add two more conditions via code and need help with syntax
please. Thank you in advance for any help you can provide.

Private Sub Form Current()
If Me![FieldName] = 1 or 2 Then
Me!PtName.BackColor = 33023
Else
Me!PtName.BackColor = 0
End If
 
G

geppo

ciao said:
I have used up my conditional formatting options in Conditional
Formatting. I am trying to add two more conditions via code and need
help with syntax please. Thank you in advance for any help you can
provide.


Private Sub Form Current()
Click to expand...

If Me![FieldName] = 1 or Me![FieldName] = 2 Then
 

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

Conditional Formatting in Code Not Working 6
Programtically Setting Conditional Formatting For a Form In Access 2007 2
Conditional Formatting and DCount (?) 2
Not printing conditional formatting 6
Conditional Formatting 7
Copying Row Code Doesn't Copy Conditional Formating 10
Need help w/conditional formatting date field 1
Conditional Formatting with VBA 4

Top