Ms Access conditional formating

  Durko 13:48 17 Dec 2005

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 2005

I've solved it now.


  Chris the Ancien 18:59 17 Dec 2005

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 2005

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 2005

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.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Microsoft Surface Book 2 hands-on review – bigger and 5x faster

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?