Conditional formating w 2 fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !!
 
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...

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 !

Ken Snell (MVP) said:
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>


Montrose guy said:
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 !!
Click to expand...
Click to expand...
 
This will be True if unsure contains Null or empty string.
Len([unsure] & "")=0

--

Ken Snell
<MS ACCESS MVP>



Montrose guy said:
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 !

Ken Snell (MVP) said:
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>


Montrose guy said:
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 !!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top