Walter,
One way of realizing your objective could be to use a simulated continuous form with multiple rows (say 12) of unbound controls. With such an arrangements you can display unlimited number of color strips row-wise.
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: John Viescas
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, September 28, 2011 11:58
Subject: RE: [MS_AccessPros] Following the color change thread
Walter-
It works in the report because the report formats each record one at a time. It
would also work in Single Form view, but it doesn't work in Continuous form view
because there is really only one copy of each control. You see multiple rows
because Access "paints" all but the current row, and it honors Conditional
Formatting as it's doing the "painting." There is no event associated with
"painting" each row in a form like there is in a report (On Format).
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: Wednesday, September 28, 2011 4:09 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Following the color change thread
Hi John;
It has a different color code for each record, each record represents a train (
back to the model RR thing) and the color is printed on a bar at the top of a
"waybill" report attached to each freight car as a visual aid in assembling a
train in the classification yard by the yard master/operator. The color bar
prints OK on the reports because I can use the "on format" event in the report,
but a 5 to 8 digit number in the "Define Trains" form is meaningless. I use a
color picker control to assign the number to the field in question.
I played with this before but got bogged down and decided to move on and return
when I felt more ambitious ;-)
Walter Griffin
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar