Different Forecolors per continuous form row?

[Vita]

I have a continuous form where I am trying to have ghost text (in the textbox format I have '@;"text"') and I am using the on enter and on exit events to change the text to black when something has been typed.
By default I want the text to be a light gray indicating that there is no text but also telling the user what goes in each field.
It works pretty good except for after I start entering text it changes the forecolor to black which also changes the forecolor on the next row.
I want the forecolor on the next row to stay gray until something is entered but have the text on the previous row be black since it has data in it.



Is this possible? If the form had an On change event I could write an if statement to check for null and set it to gray but that would run so much and it doesn't exist.

[Micron]

You cannot alter such properties in instances of a control like a textbox in a continuous form since in reality there is actually only one control. Conditional Formatting can do it though. IIRC, something has to identify the record(s) using an expression. I suppose that could be to test if the control value is not "text" then make the font black.

[June7]

Programmatically setting control properties will show same for every record because there is only one control.

Use Conditional Formatting.

Or does the solution in your other thread https://www.accessforums.net/showthread.php?t=87702 apply?

[June7]

Accidental duplicate.

[Vita]

Programmatically setting control properties will show same for every record because there is only one control.

Use Conditional Formatting.

Or does the solution in your other thread https://www.accessforums.net/showthread.php?t=87702 apply?

This worked perfect thanks!