how to highlight text

[Gerald]

how to highlight a text in color on checking on the checkbox ?

thanks

 

[Arvin Meyer [MVP]]

On a form or report, you can use Conditional formatting. In the form's
design view, just choose: Format ... Conditional Formatting. On a single
view form, you can also use code:

If Me.chkBoxName = True Then
Me.txtWhatever.BackColor = vbYellow
End If
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Gerald]

thanks

On a form or report, you can use Conditional formatting. In the form's
design view, just choose: Format ... Conditional Formatting. On a single
view form, you can also use code:

If Me.chkBoxName = True Then
Me.txtWhatever.BackColor = vbYellow
End If
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access