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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FormatCondition color based on record's field value

Status
Not open for further replies.
BjornOtto

BjornOtto

Programmer
May 21, 2009
1
US
thread702-1434007

Instead of using the hardcoded color (FC.BackColor = 9033867) how do I use the color number from a field (i.e. RecordColor) on each record? Using FC.BackColor = Me.RecordColor does not work as it picks up the color from the first record on the continuous form.
 
Status
Not open for further replies.

Similar threads

applestoapples
  • Locked
  • Question
Create duplicate rows based on Qty field
Replies
7
Views
233
Andrzejek
Andrzejek
TechieJr
  • Locked
  • Question
Filtering for null or empty field
Replies
8
Views
796
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Looking for a color chart 1
Replies
2
Views
209
BallunarCrew
BallunarCrew
MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
318
Andrzejek
Andrzejek
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
200
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top