Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page