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!

Scripts82

__________________
Scripts82

You mean at run time ?
Because if it do - you need to implement the TextChange Event (see in events Tab) and to use conditions and to set BackColor property of the TextBox .

hmm... the change event doesn't seem to fit the case...
actually not really run time....
the text boxs each contains a number (binded) to a table...
upon load, if the number in the textbox is larger than 0,
I will need the text box to be changed to a different colour

Onload doesn't work correctly ...
Change event doesn't work too as the text is not "changed" during run time...



Scripts82

Click on the textbox and then on the menu, choose FORMAT > CONDITIONAL FORMATTING. That will change the appearance of ONE box at a time vs. ALL the boxes at the same time.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

thanks! that worked fine... Didn't know this function before!

Scripts82