[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

access 2010 sample syntax/formula for conditional formatting

Posted on 2011-10-10
3
Medium Priority
?
209 Views
Last Modified: 2012-05-12
Hi
Anyone know the formla for conditional formatting - if field (text) ends with '05'
thank you.
0
Comment
Question by:COACHMAN99
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 36945701
Select "Expression Is" for the formatting type, and in the Expression textbox:

Right([YourField],2) = "05"
0
 
LVL 7

Author Closing Comment

by:COACHMAN99
ID: 36945717
excellent - thanks
0
 
LVL 61

Expert Comment

by:mbizup
ID: 36945722
Glad to help :)
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question