HELP PLEASE -- Mr Novice.

1.....I have a True/False field that I need to change on a form to be a
Red Button (text) or Background ON TRUE
Green Button (text) or Background On False.

The Action of changing the state of the True/False statement to automatically a report of records with a TRUE state, this i need to do at a particular time.

Button cannot be colored in Access.

Use a label, which is raised normally, sunken when mouse down. Set the color of the label as you desire.