Ms Access conditional formating

  Durko 13:48 17 Dec 05

Can somebody advise.

I'm trying very badly and unsuccessfully to run conditional format using ms access 2003. I've got a table that has 7 columns refering to stock supplies etc.

e.g Ref,item, bought by, supplier, price, last ordered, and current stock.

I want to raise the price records which are in pounds i.e. £13.75, 17.95, etc to highlight in colour for specific prices.

Assistance would be greatly appreciated.


  Durko 14:33 17 Dec 05

I've solved it now.


  Chris the Ancien 18:59 17 Dec 05

Glad you sorted the problem.

But it might be helpful for other users if you gave a hint as to how you did it.

Also, if the problem is cured, a green tick would be nice.

  Durko 13:40 18 Dec 05

Chris the Ancien

Rather busy at the moment but I will post the procedure later today so others can read.


  Durko 12:58 21 Dec 05

Chris the ancien.

Sorry for the delay but here's the resolution I used to resolve my query to using conditional formatting with ms access. Click option 1.

click here


This thread is now locked and can not be replied to.

Amazon Fire HD 8 review: A brilliant combination of function and value – with one massive caveat

1995-2015: How technology has changed the world in 20 years

How to create an introvert-friendly workplace

iPhone 7 review: Enhanced cameras, a refreshed design and water resistance make the iPhone 7 an…