Formatting a field in Datasheep view

[Mark O]

Hello,

I have a the following:

MyTable consisting of two fields and 3 records:
===============================================
Field 1: MyText Text (50)
Field 2: BoldIt Yes/No

This is text for Record1 No
This is text for Record2 No
This is text for Record3 No

MyMainForm containing MySubform.
MySubform displays MyTable in Datasheet view.

Problem:
I want to be able to click the BoldIt checkbox for the second record and
have only 'This is text for Record2' display in Bold font. Clicking the
same BoldIt checkbox again should unbold 'This is text for Record2'.

Thanks in advance.
Mark

 

[Steve Schapel]

Mark,

This is not possible in a table or datasheet.

In a Form in Continuous view, however, you can use Conditional
Formatting to achieve what you want here.
- Select the MyText textbox in design view of the form
- select Conditional Formatting from the Format menu
- In the 'Expression is' box, enter...
[BoldIt]=Yes
- Use the formatting controls to set it to bold font.

 

[Ron2006]

It is possible in a datasheet if you use conditional formating.

With the same logic and steps as Steve said for continuous forms


Ron

 

[Steve Schapel]

Well, what do you know! Thanks, Ron. In all my years as an Access
developer, I think I have only ever used a datasheet one time, so my
lack of experience showing here.

 

[Mark O]

Thank you very much Steve, your idea worked fine (even for Datasheet view).
Mark