Formating text boxes within a form

[MattBeas]

I have a form displaying records from a table called Stylist1. The current way of displaying these records is using "continuous forms" with only one text box displayed in the design view, this is bound to "Stylist1".

I would like to be able to display these records on a "single form" using individual text boxes in the design view.

I think I need to know how to display a specific record from a specific table within a textbox?

I want to be able to do this in order to change the colour of individual text boxes depending on a condition. I am aware of conditional formating, however this does not suit the needs due to the fact that you can only use three conditions and you can't use 'wildcards'.

Any advice would be much appreciated.
Thanks in advance!