Change Text box back colour on sub form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, i have a number of text boxes on a sub form and one of the fields is
a Yes/No field for request rejected. What i would like to hapen is; if this
field id flagged for rejected (Yes) then i want that row or a field in that
row to be red.
Could somebody please help me with this.
Thanks in advance
 
In
Les said:
Hi all, i have a number of text boxes on a sub form and one of the
fields is a Yes/No field for request rejected. What i would like to
hapen is; if this field id flagged for rejected (Yes) then i want
that row or a field in that row to be red.
Could somebody please help me with this.
Click to expand...

It sounds like Conditional Formatting would be the easy way to go with
that. You'd select one or more fields to be colored red, and choose
menu items Format -> Conditional Formatting ..., and set up the
condition for

Expression Is: [RequestRejected]

.... and set the back color for the fields to red.
 
So simple, thanks so much Dirk.... :-0)
--
Les


Dirk Goldgar said:
In
Les said:
Hi all, i have a number of text boxes on a sub form and one of the
fields is a Yes/No field for request rejected. What i would like to
hapen is; if this field id flagged for rejected (Yes) then i want
that row or a field in that row to be red.
Could somebody please help me with this.
Click to expand...

It sounds like Conditional Formatting would be the easy way to go with
that. You'd select one or more fields to be colored red, and choose
menu items Format -> Conditional Formatting ..., and set up the
condition for

Expression Is: [RequestRejected]

.... and set the back color for the fields to red.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top