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

change colur of control in a multi-rec subform 1

Status
Not open for further replies.
jackme

jackme

Programmer
Jan 16, 2001
7
0
0
IL
maybe someone can help on that.

i have a multi-rec subform and would like to change
the status filed colur when status=x.
when i tried : me!status.backcolur = 255
status field was colured in all records ???

someone ...
 
Sort by date Sort by votes
In design view, click format, and conditional formatting.
This will allow you to set different fields to differnt colors while using continuous forms. I believe this is new in Access 2000.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
174
Kennelbloke
Kennelbloke
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
135
Andrzejek
Andrzejek
JaineyBlue
  • Locked
  • Question
Cascading combo boxes in subform
Replies
11
Views
170
JaineyBlue
JaineyBlue
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
271
dhookom
dhookom
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
180
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top