Forum home » Delegate support and help forum » Microsoft Access Training and help » Conditional Formatting

Conditional Formatting

ResolvedVersion 2007

Thu 4 Dec 2008, 14:07 Delegate Paul said...

Paul has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Conditional Formatting

What is a conditional formatting?

Sat 6 Dec 2008, 11:36 Trainer Simon said...

RE: Conditional Formatting

Hi Paul,

Thank you for your question.

If you have created a form you can switch to design view and apply conditional formatting to one of the fields.

E.g. The form contains a field called Qty of Stock. If the values of the stock are greater than 100, then you can conditionally format those values in a different font colour.

The greater then 100 is the Condition and the changing the colour of the font is the format.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Conditional Formatting

Conditional Formatting

RE: Conditional Formatting

Access articles

Access tip:

Random sampling