Access Forms

[DJ18]

I have a form setup in which I am entering measurement data. Is there any way to have the measurement field flash or change color when the measurement is out of specification?

 

[jahmed]

You can use conditional formatting to change the colour of the fill, text or the font itself when the data in the field satisfies certain conditions. Simply click on Format in the menu toolbar (In design view), Conditional Formatting and select you conditions and format changes.

J. Ahmed

 

[gnosis13]

You can also toss some code into the control's "On Exit" event like

If Val(txtMeasure) > 10 then
txtMeasure.ForeColor = 255
End If
A+, N+, MCP