Trying to figure out the Syntax. In Conditional Formatting to determine if a number in a field is even. Tried "Mod 2=0" made sure I have square brackets around field name Etc...I cant figure this out. Thank you for any advise, anyone could give me.
Trying to figure out the Syntax. In Conditional Formatting to determine if a number in a field is even. Tried "Mod 2=0" made sure I have square brackets around field name Etc...I cant figure this out. Thank you for any advise, anyone could give me.
[ID] Mod 2=0 works for me?also without [] if no space in fieldname?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I keep getting invalid syntax. would you please show me how you would right the syntax in the "Expression is"
Sorry, disregard I just figured it out....Also for the cross posting I waited 10 hours with no responses so I posted here. I didn't know I was to attach a link to that other post. Thank you and Again sorry
Well, please advise that other site that issue is solved. Might also want to mark this solved here, using Thread Tools, top right of post?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
as to the "issue is solved" I just did it thanks for that, First time here still on the learning curve...lol, Thanks for all your help