Access VBA - Controlling Text boxes in a form
Hi, have a question here on controlling the appearance of a textbox in a form.
Currently, I have a form which is has its recordsource linked to a table with 5 records.
Each of these records have the Field -> "Cost"
The form, when loaded, will display all 5 records in a "Continuous Forms View". The "Cost" Field is displayed as a textbox.
How do I, using VBA, control the appearance of the text boxes?
For example, if "Cost" > 10, Use Black background for the textbox
and if "Cost" <=9, Use Green background for the text?
Any help will be greatly appreciated!