Walter-
No can do. If this were a single form view, you could use the Current event to
pick up the color code and assign it. How many different color codes do you
have, and why is it stored in the table?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
Sent: Tuesday, September 27, 2011 7:47 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Following the color change thread
Hi Group;
I followed along on the color change field thread and tried the conditional
format thing on a form of mine I have that displays a decimal number value of a
color in a bound textbox on a continuous form the number is really meaningless
tot he user so I want to show the color,I set the background to "Normal" and I
tried this
[txtRecordColor.BackColor]=[txtRecordColor] from the conditional format wiz in
2010, No joy!
Tried this also
[txtRecordColor.BackColor]=hex([txtRecordColor])
just in case, also no joy!
What am I doing wrong?
Walter Griffin
------------------------------------
Yahoo! Groups Links
Selasa, 27 September 2011
RE: [MS_AccessPros] Following the color change thread
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar