Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Formatting a field in Datasheep view

Discussion in 'Information Technology' started by Mark O, Jul 28, 2006.

  1. Mark O

    Mark O
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    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.

    --
    Steve Schapel, Microsoft Access MVP


    Mark O wrote:
    > 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
    >
     
  4. Ron2006

    Ron2006
    Expand Collapse
    Guest

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

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


    Ron
     
  5. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    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.

    --
    Steve Schapel, Microsoft Access MVP

    Ron2006 wrote:
    > It is possible in a datasheet if you use conditional formating.
    >
    > With the same logic and steps as Steve said for continuous forms
     
  6. Mark O

    Mark O
    Expand Collapse
    Guest

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

    Steve Schapel wrote:
    > 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.
    >
     

Share This Page