Formatting Individual Records in Reports

[Guest]

I've tried to "bold" individual records as a way, short of grouping" that I
can lable subcategories in my report, simply by making, e.g., a record which
is a title occupying a principal text field but has no other fields
completed.

I've tried conditional formatting, both with field values and expressions,
but I can only format one record at a time, that is, when I move farther
down the data to format bold a new subcategory title by using conditional
formatting, the earlier formatted subcategory title losses its formatting,
reverting to the default format for the table.

Any ideas on how this can be done simply, without grouping?

 

[Duane Hookom]

I'm confused by what you want to do, what you have tried, and your results.
Conditional formatting applies to a control. A control is bound to every
record in the report's record source.

Can you be a little more specific on what you want, tried, and expect?

 

[Guest]

I want to be able to format as bold certain individual records in a
900-records report. There would be about 15 or 16 records that I would want
to be formatted as bold in the entire report (the "Label Only Records").
Whereas all the other records contain data in at least a dozen fields and
that data takes the default unbolded font (the "Regular Records"), the Label
Records each only contain data (text) in one field and that text is to be
used to create a simple , but quite visible, label for the next several
Regular Records to follow in the report without resorting to formally
grouping records.

I've tried to select one Label Record to format as bold, but the entire
report is formatted bold, whether I do that in the Table view or in Reports
layout view. I was able to format all the records in one field, but I've
forgotten what technique I used to do that.

I tried conditional formatting in layout view. If I use the "field value"
as the condition for one of the Label Records and try to use it for the
second Label record, the second Label Record is formatted bold but the first
Label Record reverts to the default, unbolded font.

I have one field that has little data so I can enter in that field "a", for
example as an Expression, to represent "title." With that field and "="a"",
I can bold the Label Record to which that condition has been applied. When
I attempt to use the same technique on the second Label Record and use "c"
as an expression (representing the first letter of the label, for
convenience) as the condition for bolding the second Lable Record, that
works for the second Label Record but the first Label Record reverts to the
default unbolded font.

This what I've tried so far.

 

[Guest]

I'm attempting to send my answers to Duane Hook's questions, but his SPAM
blocker appears to block my reply. How Can I answer these questions?



Jim Mohundro

 

[Duane Hookom]

Since "each only contain data (text) in one field" I expect you can change
the conditional formatting of the text box to use "Expression Is" (sp?) and
set the condition to:
[SomeOtherField] & "" = ""

 

[John Spencer]

by posting the response in this forum as a response to this thread as you
just posted the request for how do I ...?



--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

For Duane Hookom:

I probably don't understand the syntax, but I literally used the example
(except for using the correct Field Name for the otherwise unused field) for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field name]space&space""space=space""

I tried this with no data in [other field] and all records in the field were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The epression you
entered contains invalid syntax. You may have entered an operand with an
operator.

 

[Guest]

Thanks for the advice. I'm sorry for the redundancy, but I'll post it again
here.

For Duane Hookom:

I probably don't understand the syntax, but I literally used the example
(except for using the correct Field Name for the otherwise unused field) for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field name]space&space""space=space""

I tried this with no data in [other field] and all records in the field were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The epression you
entered contains invalid syntax. You may have entered an operand with an
operator.

 

[Duane Hookom]

I just tested this with this exact expression and some records with no value
in [NotherField]. I got exactly what I expected.
[NotherField] & ""=""

By chance do you have the format set to bold in the design view?

--
Duane Hookom
Microsoft Access MVP

For Duane Hookom:

I probably don't understand the syntax, but I literally used the example
(except for using the correct Field Name for the otherwise unused field) for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field name]space&space""space=space""

I tried this with no data in [other field] and all records in the field were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The epression you
entered contains invalid syntax. You may have entered an operand with an
operator.

I've tried to "bold" individual records as a way, short of grouping" that
I can lable subcategories in my report, simply by making, e.g., a record
which is a title occupying a principal text field but has no other fields
completed.

I've tried conditional formatting, both with field values and expressions,
but I can only format one record at a time, that is, when I move farther
down the data to format bold a new subcategory title by using conditional
formatting, the earlier formatted subcategory title losses its formatting,
reverting to the default format for the table.

Any ideas on how this can be done simply, without grouping?

 

[Guest]

I checked design view and it is okay there.

I again reviewed the expression condition (making sure there was no data in
[RecorUpdate} (my "NotherField}.

Here is what I've done:

In the Conditional Formatting dialogue box:

Condition 1
Expression Is [RecorUpdate] & ""=""

Preview of format to use when condition is true
(I used the "B" to select the format).

All the keystrokes (except for the field name) follow yours, including the
spaces, the ampersand and the double quotation markes on each side of the
equals sign.

My result is that all records in the field are bold.

I just tested this with this exact expression and some records with no
value
in [NotherField]. I got exactly what I expected.
[NotherField] & ""=""

By chance do you have the format set to bold in the design view?

--
Duane Hookom
Microsoft Access MVP

For Duane Hookom:

I probably don't understand the syntax, but I literally used the example
(except for using the correct Field Name for the otherwise unused field)
for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field
name]space&space""space=space""

I tried this with no data in [other field] and all records in the field
were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The epression
you
entered contains invalid syntax. You may have entered an operand with an
operator.

I've tried to "bold" individual records as a way, short of grouping"
that
I can lable subcategories in my report, simply by making, e.g., a
record
which is a title occupying a principal text field but has no other
fields
completed.

I've tried conditional formatting, both with field values and
expressions,
but I can only format one record at a time, that is, when I move
farther
down the data to format bold a new subcategory title by using
conditional
formatting, the earlier formatted subcategory title losses its
formatting,
reverting to the default format for the table.

Any ideas on how this can be done simply, without grouping?

 

[Duane Hookom]

Then I expect the value of the field isn't what either you or I expect. Tr
Expression Is Len(Trim([RecorUpdate])) = 0

--
Duane Hookom
Microsoft Access MVP

I checked design view and it is okay there.

I again reviewed the expression condition (making sure there was no data in
[RecorUpdate} (my "NotherField}.

Here is what I've done:

In the Conditional Formatting dialogue box:

Condition 1
Expression Is [RecorUpdate] & ""=""

Preview of format to use when condition is true
(I used the "B" to select the format).

All the keystrokes (except for the field name) follow yours, including the
spaces, the ampersand and the double quotation markes on each side of the
equals sign.

My result is that all records in the field are bold.

I just tested this with this exact expression and some records with no
value
in [NotherField]. I got exactly what I expected.
[NotherField] & ""=""

By chance do you have the format set to bold in the design view?

--
Duane Hookom
Microsoft Access MVP

For Duane Hookom:

I probably don't understand the syntax, but I literally used the example
(except for using the correct Field Name for the otherwise unused field)
for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field
name]space&space""space=space""

I tried this with no data in [other field] and all records in the field
were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The epression
you
entered contains invalid syntax. You may have entered an operand with an
operator.

I've tried to "bold" individual records as a way, short of grouping"
that
I can lable subcategories in my report, simply by making, e.g., a
record
which is a title occupying a principal text field but has no other
fields
completed.

I've tried conditional formatting, both with field values and
expressions,
but I can only format one record at a time, that is, when I move
farther
down the data to format bold a new subcategory title by using
conditional
formatting, the earlier formatted subcategory title losses its
formatting,
reverting to the default format for the table.

Any ideas on how this can be done simply, without grouping?

 

[Guest]

I copied and pasted your expression into the conditional formatiting
dialogue box in layout view and the record was not bolded (nor were any
other records, at least). Since there doesn't seem to be anything in the MS
Knowledgment Base addressing this, either no one else has ever seen the need
or it simply can't be done.



Jim Mohundro

Then I expect the value of the field isn't what either you or I expect. Tr
Expression Is Len(Trim([RecorUpdate])) = 0

--
Duane Hookom
Microsoft Access MVP

I checked design view and it is okay there.

I again reviewed the expression condition (making sure there was no data
in
[RecorUpdate} (my "NotherField}.

Here is what I've done:

In the Conditional Formatting dialogue box:

Condition 1
Expression Is [RecorUpdate] & ""=""

Preview of format to use when condition is true
(I used the "B" to select the format).

All the keystrokes (except for the field name) follow yours, including
the
spaces, the ampersand and the double quotation markes on each side of the
equals sign.

My result is that all records in the field are bold.

I just tested this with this exact expression and some records with no
value
in [NotherField]. I got exactly what I expected.
[NotherField] & ""=""

By chance do you have the format set to bold in the design view?

--
Duane Hookom
Microsoft Access MVP


:

For Duane Hookom:

I probably don't understand the syntax, but I literally used the
example
(except for using the correct Field Name for the otherwise unused
field)
for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field
name]space&space""space=space""

I tried this with no data in [other field] and all records in the
field
were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The
epression
you
entered contains invalid syntax. You may have entered an operand with
an
operator.

I've tried to "bold" individual records as a way, short of grouping"
that
I can lable subcategories in my report, simply by making, e.g., a
record
which is a title occupying a principal text field but has no other
fields
completed.

I've tried conditional formatting, both with field values and
expressions,
but I can only format one record at a time, that is, when I move
farther
down the data to format bold a new subcategory title by using
conditional
formatting, the earlier formatted subcategory title losses its
formatting,
reverting to the default format for the table.

Any ideas on how this can be done simply, without grouping?

 

[Guest]

Thanks to Duane Hookom for giving it a good shot. For your information, I
got a work-around
from a tech at Microsoft a couple of days ago.



Jim Mohundro

I copied and pasted your expression into the conditional formatiting
dialogue box in layout view and the record was not bolded (nor were any
other records, at least). Since there doesn't seem to be anything in the
MS Knowledgment Base addressing this, either no one else has ever seen the
need or it simply can't be done.



Jim Mohundro

Then I expect the value of the field isn't what either you or I expect.
Tr
Expression Is Len(Trim([RecorUpdate])) = 0

--
Duane Hookom
Microsoft Access MVP

I checked design view and it is okay there.

I again reviewed the expression condition (making sure there was no data
in
[RecorUpdate} (my "NotherField}.

Here is what I've done:

In the Conditional Formatting dialogue box:

Condition 1
Expression Is [RecorUpdate] & ""=""

Preview of format to use when condition is true
(I used the "B" to select the format).

All the keystrokes (except for the field name) follow yours, including
the
spaces, the ampersand and the double quotation markes on each side of
the
equals sign.

My result is that all records in the field are bold.



I just tested this with this exact expression and some records with no
value
in [NotherField]. I got exactly what I expected.
[NotherField] & ""=""

By chance do you have the format set to bold in the design view?

--
Duane Hookom
Microsoft Access MVP


:

For Duane Hookom:

I probably don't understand the syntax, but I literally used the
example
(except for using the correct Field Name for the otherwise unused
field)
for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field
name]space&space""space=space""

I tried this with no data in [other field] and all records in the
field
were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The
epression
you
entered contains invalid syntax. You may have entered an operand
with an
operator.

I've tried to "bold" individual records as a way, short of
grouping"
that
I can lable subcategories in my report, simply by making, e.g., a
record
which is a title occupying a principal text field but has no other
fields
completed.

I've tried conditional formatting, both with field values and
expressions,
but I can only format one record at a time, that is, when I move
farther
down the data to format bold a new subcategory title by using
conditional
formatting, the earlier formatted subcategory title losses its
formatting,
reverting to the default format for the table.

Any ideas on how this can be done simply, without grouping?

 

[Duane Hookom]

Could you share the work around?
--
Duane Hookom
Microsoft Access MVP

Thanks to Duane Hookom for giving it a good shot. For your information, I
got a work-around
from a tech at Microsoft a couple of days ago.



Jim Mohundro

I copied and pasted your expression into the conditional formatiting
dialogue box in layout view and the record was not bolded (nor were any
other records, at least). Since there doesn't seem to be anything in the
MS Knowledgment Base addressing this, either no one else has ever seen the
need or it simply can't be done.



Jim Mohundro

Then I expect the value of the field isn't what either you or I expect.
Tr
Expression Is Len(Trim([RecorUpdate])) = 0

--
Duane Hookom
Microsoft Access MVP


:

I checked design view and it is okay there.

I again reviewed the expression condition (making sure there was no data
in
[RecorUpdate} (my "NotherField}.

Here is what I've done:

In the Conditional Formatting dialogue box:

Condition 1
Expression Is [RecorUpdate] & ""=""

Preview of format to use when condition is true
(I used the "B" to select the format).

All the keystrokes (except for the field name) follow yours, including
the
spaces, the ampersand and the double quotation markes on each side of
the
equals sign.

My result is that all records in the field are bold.



I just tested this with this exact expression and some records with no
value
in [NotherField]. I got exactly what I expected.
[NotherField] & ""=""

By chance do you have the format set to bold in the design view?

--
Duane Hookom
Microsoft Access MVP


:

For Duane Hookom:

I probably don't understand the syntax, but I literally used the
example
(except for using the correct Field Name for the otherwise unused
field)
for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field
name]space&space""space=space""

I tried this with no data in [other field] and all records in the
field
were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The
epression
you
entered contains invalid syntax. You may have entered an operand
with an
operator.

I've tried to "bold" individual records as a way, short of
grouping"
that
I can lable subcategories in my report, simply by making, e.g., a
record
which is a title occupying a principal text field but has no other
fields
completed.

I've tried conditional formatting, both with field values and
expressions,
but I can only format one record at a time, that is, when I move
farther
down the data to format bold a new subcategory title by using
conditional
formatting, the earlier formatted subcategory title losses its
formatting,
reverting to the default format for the table.

Any ideas on how this can be done simply, without grouping?

 

[Guest]

Here is the work-around (it's for a database of films for collectors):

Where [Title} is the field in which the formatting is to be used, the MS
tech had me add the word "Movies" to each record to be used as a "label"
inside of the report without restructuring the report into groups.

The form in the conditional formatting box is

Expression is [title] Like "*Movies"

e.g.,

Action Movies
Comedy Movies
Drama Movies
Horror Movies

etc.

Jim Mohundro

Could you share the work around?
--
Duane Hookom
Microsoft Access MVP

Thanks to Duane Hookom for giving it a good shot. For your information,
I
got a work-around
from a tech at Microsoft a couple of days ago.



Jim Mohundro

I copied and pasted your expression into the conditional formatiting
dialogue box in layout view and the record was not bolded (nor were any
other records, at least). Since there doesn't seem to be anything in
the
MS Knowledgment Base addressing this, either no one else has ever seen
the
need or it simply can't be done.



Jim Mohundro
Then I expect the value of the field isn't what either you or I
expect.
Tr
Expression Is Len(Trim([RecorUpdate])) = 0

--
Duane Hookom
Microsoft Access MVP


:

I checked design view and it is okay there.

I again reviewed the expression condition (making sure there was no
data
in
[RecorUpdate} (my "NotherField}.

Here is what I've done:

In the Conditional Formatting dialogue box:

Condition 1
Expression Is [RecorUpdate] & ""=""

Preview of format to use when condition is true
(I used the "B" to select the format).

All the keystrokes (except for the field name) follow yours,
including
the
spaces, the ampersand and the double quotation markes on each side of
the
equals sign.

My result is that all records in the field are bold.



I just tested this with this exact expression and some records with
no
value
in [NotherField]. I got exactly what I expected.
[NotherField] & ""=""

By chance do you have the format set to bold in the design view?

--
Duane Hookom
Microsoft Access MVP


:

For Duane Hookom:

I probably don't understand the syntax, but I literally used the
example
(except for using the correct Field Name for the otherwise unused
field)
for
this condition: Expression is [other field name] & "" = ""

where these were my keystrokes: [other field
name]space&space""space=space""

I tried this with no data in [other field] and all records in the
field
were
bolded. Then I tried with the number 1 in [other field] and
space&space""space=1space"" and I got this error message: The
epression
you
entered contains invalid syntax. You may have entered an operand
with an
operator.

I've tried to "bold" individual records as a way, short of
grouping"
that
I can lable subcategories in my report, simply by making, e.g.,
a
record
which is a title occupying a principal text field but has no
other
fields
completed.

I've tried conditional formatting, both with field values and
expressions,
but I can only format one record at a time, that is, when I move
farther
down the data to format bold a new subcategory title by using
conditional
formatting, the earlier formatted subcategory title losses its
formatting,
reverting to the default format for the table.

Any ideas on how this can be done simply, without grouping?