Changing property to bold

[Renegade4]

My client is requesting that a single record in a sub-form
be displayed in bold if a checkbox (the first field in the
record) is checked. Setting FONTBOLD=TRUE or
FONTWEIGHT=700 sets all records on the sub-form to bold.

Any insight (other than creating variables for each record
[very ugly prospect]) on how to set an individual record's
property to bold? I saw a post about this a while ago,
but can't remember where.

This is being developed in Access '97 (ugh...) The client
is always right!

Thanks in advance.

R4

 

[Jim/Chris]

Have you tried using conditional formatting. It is under
Tools/Conditional Formatting.

Use Expression is
Forms![formname]![checkboxname]=yes
click the bold icon


Jim

 

[Renegade4]

-----Original Message-----
Have you tried using conditional formatting. It is under
Tools/Conditional Formatting.

Use Expression is
Forms![formname]![checkboxname]=yes
click the bold icon


Jim

Hi Jim,

Thanks for the reply.

Firstly, I do not find Conditional Formatting under Tools
in my version of Access 97.

I am using conditional (IF...THEN) formatting in an Event
Procedure based on the state of the checkbox. This,
however applies the result of the condition, in this case
the bold property, to all records displayed on the form.

There is a checkbox as the first field of every record and
I am searching for a way to only apply the bold property
to records in which the checkbox has been checked.

R4

 

[Brendan Reynolds \(MVP\)]

I believe Conditional Formatting was new in Access 2000.

Stephen Lebans's solution at the following URL may help ...

http://www.lebans.com/formatbycriteria.htm

--
Brendan Reynolds (MVP)
(e-mail address removed)

-----Original Message-----
Have you tried using conditional formatting. It is under
Tools/Conditional Formatting.

Use Expression is
Forms![formname]![checkboxname]=yes
click the bold icon


Jim

Hi Jim,

Thanks for the reply.

Firstly, I do not find Conditional Formatting under Tools
in my version of Access 97.

I am using conditional (IF...THEN) formatting in an Event
Procedure based on the state of the checkbox. This,
however applies the result of the condition, in this case
the bold property, to all records displayed on the form.

There is a checkbox as the first field of every record and
I am searching for a way to only apply the bold property
to records in which the checkbox has been checked.

R4

 

[Renegade4]

Hi Brendan,

Thanks for your reply to my problem. I thought
Conditional Formatting was introduced in Access 2000. I
haven't even checked yet as I'm under pressure to complete
this database ASAP. I moved on to other facets of this
project and have not had a chance to check the url you
sent me. I'll let you know how it goes.

Thanks again,

R4