Conditional formating w 2 fields

[Montrose guy]

I have a database of books I own in Access/.Office 2003.. I have a query
that seperates a specific genre (sci-fi, mystery etc) and I have designed a
report to print a list of one genre or a combo or a complete listing. One
of the feilds for each record is a ONE character field labeled 'unsure' which
I assign a specific letter (U=unread P=paperback H=hardcover) I would like to
have my book TITLE field in the report print a different color and perhaps
bold for any record that has a U in the 'unsure' field so the end result
would be that if I print a list of all my Mystery books, the titles I have
yet to read will be printed in another color and bold. Please help !!

 

[Ken Snell \(MVP\)]

Use Conditional Formatting on that title field. Select Expression Is as the
type; put this expression in the next box:
[unsure]="U"

Then set the Bold, FontColor, etc. attributes for when this expression is
True.

 

[Montrose guy]

Ken...

THANK YOU.. that answered the question perfectly !!

One one question in the same vein.. what would the expression be if the
field (ex. [unsure]) has NO DATA and I want specify a font attribute for
those ? I realize I could also think of another letter to designate all the
blanks - but I'm thinking there is a way to express those WITHOUT data in
that field..

Thanks in advance !

Use Conditional Formatting on that title field. Select Expression Is as the
type; put this expression in the next box:
[unsure]="U"

Then set the Bold, FontColor, etc. attributes for when this expression is
True.

--

Ken Snell
<MS ACCESS MVP>

I have a database of books I own in Access/.Office 2003.. I have a query
that seperates a specific genre (sci-fi, mystery etc) and I have designed
a
report to print a list of one genre or a combo or a complete listing.
One
of the feilds for each record is a ONE character field labeled 'unsure'
which
I assign a specific letter (U=unread P=paperback H=hardcover) I would like
to
have my book TITLE field in the report print a different color and perhaps
bold for any record that has a U in the 'unsure' field so the end result
would be that if I print a list of all my Mystery books, the titles I have
yet to read will be printed in another color and bold. Please help !!

 

[Ken Snell \(MVP\)]

This will be True if unsure contains Null or empty string.
Len([unsure] & "")=0

--

Ken Snell
<MS ACCESS MVP>

Ken...

THANK YOU.. that answered the question perfectly !!

One one question in the same vein.. what would the expression be if the
field (ex. [unsure]) has NO DATA and I want specify a font attribute for
those ? I realize I could also think of another letter to designate all
the
blanks - but I'm thinking there is a way to express those WITHOUT data in
that field..

Thanks in advance !

Use Conditional Formatting on that title field. Select Expression Is as
the
type; put this expression in the next box:
[unsure]="U"

Then set the Bold, FontColor, etc. attributes for when this expression is
True.

--

Ken Snell
<MS ACCESS MVP>

I have a database of books I own in Access/.Office 2003.. I have a
query
that seperates a specific genre (sci-fi, mystery etc) and I have
designed
a
report to print a list of one genre or a combo or a complete listing.
One
of the feilds for each record is a ONE character field labeled 'unsure'
which
I assign a specific letter (U=unread P=paperback H=hardcover) I would
like
to
have my book TITLE field in the report print a different color and
perhaps
bold for any record that has a U in the 'unsure' field so the end
result
would be that if I print a list of all my Mystery books, the titles I
have
yet to read will be printed in another color and bold. Please help !!