In one of my tables, in addition to a text field that is a Description
field, there are two fields for color formatting the data in reports.
They are Longs and hold the foreground and background color values that
the Description in that record should be displayed in. For example, the
following records might exist...
Bass - 255 - 16777215 (The word BASS displayed red on white)
Carp - 65535 - 0 (The word CAR displayed yellow on black)
Fish - 33023 - 8388672 (The word FISH displayed orange on purple)
There could be any number of records, most likely 10-15 but could be
more or less.
I would like to be able to display a legend on one of my forms that
displays each Description formatted with its given fore/back color
combination. I have taken a stupid pill and can't figure out how to do
this. Can anyone help me here please?
8  3335 
On Wed, 20 Sep 2006 17:14:43 -0400, Swans, What Swans?
<fz@barkingpumpkin.ooowrote:
I'm assuming you know how to create a subreport.
Then to color each field, write code in the OnFormat event. Something
like:
txtFishName.BackColor = BackColor
txtFishName.ForeColor = ForeColor
BackColor and ForeColor would be columns in your query that this
(sub)report is bound to.
-Tom.
>In one of my tables, in addition to a text field that is a Description
field, there are two fields for color formatting the data in reports.
They are Longs and hold the foreground and background color values that
the Description in that record should be displayed in. For example, the
following records might exist...
Bass - 255 - 16777215 (The word BASS displayed red on white)
Carp - 65535 - 0 (The word CAR displayed yellow on black)
Fish - 33023 - 8388672 (The word FISH displayed orange on purple)
There could be any number of records, most likely 10-15 but could be
more or less.
I would like to be able to display a legend on one of my forms that
displays each Description formatted with its given fore/back color
combination. I have taken a stupid pill and can't figure out how to do
this. Can anyone help me here please?
In article <j9********************************@4ax.com>, no.spam.tom7744
@cox.net says...
On Wed, 20 Sep 2006 17:14:43 -0400, Swans, What Swans?
<fz@barkingpumpkin.ooowrote:
I'm assuming you know how to create a subreport.
Then to color each field, write code in the OnFormat event. Something
like:
txtFishName.BackColor = BackColor
txtFishName.ForeColor = ForeColor
BackColor and ForeColor would be columns in your query that this
(sub)report is bound to.
-Tom.
In one of my tables, in addition to a text field that is a Description
field, there are two fields for color formatting the data in reports.
They are Longs and hold the foreground and background color values that
the Description in that record should be displayed in. For example, the
following records might exist...
Bass - 255 - 16777215 (The word BASS displayed red on white)
Carp - 65535 - 0 (The word CAR displayed yellow on black)
Fish - 33023 - 8388672 (The word FISH displayed orange on purple)
There could be any number of records, most likely 10-15 but could be
more or less.
I would like to be able to display a legend on one of my forms that
displays each Description formatted with its given fore/back color
combination. I have taken a stupid pill and can't figure out how to do
this. Can anyone help me here please?
I have actually considered a sub-report however the sizing is an issue.
How do I set it so that the report displays on the screen in the size I
want it? Cant get it to do what I want. AFAIK I have to have a print
driver for whatever printer is going to generate the report and then
find a paper size that I want to use, format it all to fit and it just
does not work. I have an area about 2=3F" wide to fit this legend. I
have yet to find a printer that supports 2=3F" paper width. I really may
be a total dumb ass on this and maybe I am missing something obvious,
but I need an answer that will be a universal fix w/o and requirements
such as a specific printer.
In article <j9********************************@4ax.com>, no.spam.tom7744
@cox.net says...
On Wed, 20 Sep 2006 17:14:43 -0400, Swans, What Swans?
<fz@barkingpumpkin.ooowrote:
I'm assuming you know how to create a subreport.
Then to color each field, write code in the OnFormat event. Something
like:
txtFishName.BackColor = BackColor
txtFishName.ForeColor = ForeColor
BackColor and ForeColor would be columns in your query that this
(sub)report is bound to.
-Tom.
In one of my tables, in addition to a text field that is a Description
field, there are two fields for color formatting the data in reports.
They are Longs and hold the foreground and background color values that
the Description in that record should be displayed in. For example, the
following records might exist...
Bass - 255 - 16777215 (The word BASS displayed red on white)
Carp - 65535 - 0 (The word CAR displayed yellow on black)
Fish - 33023 - 8388672 (The word FISH displayed orange on purple)
There could be any number of records, most likely 10-15 but could be
more or less.
I would like to be able to display a legend on one of my forms that
displays each Description formatted with its given fore/back color
combination. I have taken a stupid pill and can't figure out how to do
this. Can anyone help me here please?
Also, I was not aware you could put a subreport on a form. I hadnt ever
tried that. When I use the subform/report tool on a form all it allows
me to do is display a subform.
....assuming that these values are dynamic, I know of no "simple" way to do
this
....as always, when in need of doing something difficult, see www.lebans.com
....the SubClassFormatByCriteria sample mdb should give you what you need.
....hth
William Hindman
<Swans>; "What Swans?" <fz@barkingpumpkin.ooowrote in message
news:MP***********************@newsgroups.comcast. net...
In one of my tables, in addition to a text field that is a Description
field, there are two fields for color formatting the data in reports.
They are Longs and hold the foreground and background color values that
the Description in that record should be displayed in. For example, the
following records might exist...
Bass - 255 - 16777215 (The word BASS displayed red on white)
Carp - 65535 - 0 (The word CAR displayed yellow on black)
Fish - 33023 - 8388672 (The word FISH displayed orange on purple)
There could be any number of records, most likely 10-15 but could be
more or less.
I would like to be able to display a legend on one of my forms that
displays each Description formatted with its given fore/back color
combination. I have taken a stupid pill and can't figure out how to do
this. Can anyone help me here please?
On Thu, 21 Sep 2006 01:42:21 -0400, Swans, What Swans?
<fz@barkingpumpkin.ooowrote:
No you can't. I picked up on your "...two fields for color formatting
the data in reports..." and figured you wanted to create a report.
Upon second reading of your OP I am confused. You want color
formatting in reports, but the legend in a form???
-Tom.
>In article <j9********************************@4ax.com>, no.spam.tom7744
@cox.net says...
>On Wed, 20 Sep 2006 17:14:43 -0400, Swans, What Swans?
<fz@barkingpumpkin.ooowrote:
I'm assuming you know how to create a subreport.
Then to color each field, write code in the OnFormat event. Something
like:
txtFishName.BackColor = BackColor
txtFishName.ForeColor = ForeColor
BackColor and ForeColor would be columns in your query that this
(sub)report is bound to.
-Tom.
>In one of my tables, in addition to a text field that is a Description
field, there are two fields for color formatting the data in reports.
They are Longs and hold the foreground and background color values that
the Description in that record should be displayed in. For example, the
following records might exist...
Bass - 255 - 16777215 (The word BASS displayed red on white)
Carp - 65535 - 0 (The word CAR displayed yellow on black)
Fish - 33023 - 8388672 (The word FISH displayed orange on purple)
There could be any number of records, most likely 10-15 but could be
more or less.
I would like to be able to display a legend on one of my forms that
displays each Description formatted with its given fore/back color
combination. I have taken a stupid pill and can't figure out how to do
this. Can anyone help me here please?
Also, I was not aware you could put a subreport on a form. I hadnt ever
tried that. When I use the subform/report tool on a form all it allows
me to do is display a subform.
In article <mM******************************@adelphia.com>, wd*******@adelphia.net says...
...assuming that these values are dynamic, I know of no "simple" way to do
this
...as always, when in need of doing something difficult, see www.lebans.com
...the SubClassFormatByCriteria sample mdb should give you what you need.
...hth
William Hindman
<Swans>; "What Swans?" <fz@barkingpumpkin.ooowrote in message
news:MP***********************@newsgroups.comcast. net...
In one of my tables, in addition to a text field that is a Description
field, there are two fields for color formatting the data in reports.
They are Longs and hold the foreground and background color values that
the Description in that record should be displayed in. For example, the
following records might exist...
Bass - 255 - 16777215 (The word BASS displayed red on white)
Carp - 65535 - 0 (The word CAR displayed yellow on black)
Fish - 33023 - 8388672 (The word FISH displayed orange on purple)
There could be any number of records, most likely 10-15 but could be
more or less.
I would like to be able to display a legend on one of my forms that
displays each Description formatted with its given fore/back color
combination. I have taken a stupid pill and can't figure out how to do
this. Can anyone help me here please?
Yes thats it. The data are printed and formatted (colored) in the main
report. This report is displayed on the form with the snapshot viewer
control. I would like to add to the form (as opposed to the bottom of
the report as a report or page footer) a legend of the color scheme for
the data displayed in the snapshot.
Swans wrote:
Bass - 255 - 16777215 (The word BASS displayed red on white)
Carp - 65535 - 0 (The word CAR displayed yellow on black)
Fish - 33023 - 8388672 (The word FISH displayed orange on purple)
I would like to be able to display a legend on one of my forms that
displays each Description formatted with its given fore/back color
combination. I have taken a stupid pill and can't figure out how to do
this. Can anyone help me here please?
HAve you tried the on format event in the detail section?
Assuming:
1) your field names are fdFish, fdFore, fdBack;
2) a report bound to a query of the fish and colour table; and
3) you have a text box called txtDisplay with a controlsource of fdFish.
Try the following in the detail on format event:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.txtDisplay.BackColor = Me.fdBack.Value
Me.txtDisplay.ForeColor = Me.fdFore.Value
End Sub
It works just fine in the quick test I just did.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Tim Marshall wrote:
HAve you tried the on format event in the detail section?
Disregard - my suggestion was for a report, not a form.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jorl Shefner |
last post by:
I've only been able to plot data with both symbols and lines by
issuing two plot commands, one for markers and one for lines. That's
perfectly fine, but it creates a problem when I try to create a...
|
by: Jorl Shefner |
last post by:
I have a problem that I run into a lot with the 'legend' command's
default behavior. I've found a work-around but I wonder if there's a
better way.
For a simple example, take the following:...
|
by: Philip |
last post by:
Hi,
I am trying to output certain nodes inside another. I have an xml
template with field definitions for a form, and this includes
textfields, labels, checkboxes etc plus fieldssets. I defined...
|
by: Mitch |
last post by:
I am using Access to create an Excel spreadsheets with graphs related
to rows on the sheet1 to the graph on sheet2. I am using the same data
but different subsets of the data to make different...
|
by: dubing |
last post by:
Hi,
We have some html source like this:
<div class="survey">
<form action="students/cbe-graduate-students/survey.html"
method="post" id="frmPbSurvey">
<fieldset class="survey_item">...
|
by: Dirntknow |
last post by:
Further to my recent post in this newsgroup i've got to admit i'm
struggling. I've no experience with javascript or it's workings. What i'd
like is a simple converter to allow a user to input the...
|
by: bdbeames |
last post by:
Ok I have a form validation problem that I need one of you javascript ninja s to help me with.
The following is a form with the javascript that I have used for the last year or two to validate. ...
|
by: dkyadav80 |
last post by:
<html>
///
here what shoud be java script for:
->when script run then not display all input text field only display selection field.
->when user select other value for institute only this...
|
by: Hvid Hat |
last post by:
Hi
Can anyone help me with the following transition? My problem is how to create
a fieldset each time I run into a heading and then include the following text
elements within the fieldset.
...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
