Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Forms

Status
Not open for further replies.
DJ18

DJ18

MIS
Jan 5, 2003
5
US
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?
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Question
Access VBA Syntax Error
Replies
3
Views
98
SoftwareRT
SoftwareRT
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
844
grnzbra
grnzbra
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
655
OCM
OCM
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
366
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
622
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top