I am creating a form to show the status of orders, and ideally want to change the colour of the text to reflect the status of the order - e.g. red if its late, yellow if its on time and blue if its ahead.
I would appreciate it greatly if somone could tell me how to achieve this, and what view (form/datasheet) it can be used with.
Try searching for help on 'Conditional Formatting'. In essence click Format on the toolbar and select Conditional Formatting. Whilst the test box in the form is slected, you can create different conditions for the text or background colour to change dependant on what is displayed in the box. Have a play with it and get your best results from that.