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

Format one field in bold in a trim expression

Discussion in 'Information Technology' started by jean.ulrich@snclavalin.com, Jul 28, 2006.

  1. jean.ulrich@snclavalin.com

    jean.ulrich@snclavalin.com
    Expand Collapse
    Guest

    Hi

    I have a trim expression

    Trim([Name] & ", " & [FirstName] & ", " & "born on the " & [BornDate] &
    " in the city of " & [CityName])

    Is it possible in this expression to apply bold format only for
    [BornDate] ?

    thanks
     
  2. Loading...

    Similar Threads Forum Date
    India Indian ‘Journalist’ Slams Gurbaksh Singh Than Admits to Receiving Information from ‘Agencies’ Breaking News Dec 27, 2013
    Opinion West Punjab : Information Pool and Pictures Punjab, Punjabi, Punjabiyat Nov 18, 2013
    When Turban Turns Messenger Diaspora Finds Interesting Ways to Spread Information About Sikhi Sikh Youth Nov 10, 2013
    Story of Transformation Sikh Rehat Maryada Jul 27, 2012
    Sikhism Benti Chaupai - Keertan Format Videos Feb 11, 2012

  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    No. Formats such as font, italic, bolding, etc. are an all or nothing option
    for textboxes, unless you are using a memo data type with a Rich Text ActiveX
    control.

    Two rich text controls worthy of mention include:
    http://www.lebans.com/richtext.htm (Free) and

    http://www.fmsinc.com/products/memo/index.html (Not free).


    > Trim([Name] &


    Please note that "Name" is a reserved word. You should avoid using reserved
    words for anything that you assign a name to in Access:

    Reserved Words in Microsoft Access
    http://support.microsoft.com/?id=286335

    List of reserved words in Jet 4.0
    http://support.microsoft.com/?id=321266



    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "jean.ulrich@snclavalin.com" wrote:

    > Hi
    >
    > I have a trim expression
    >
    > Trim([Name] & ", " & [FirstName] & ", " & "born on the " & [BornDate] &
    > " in the city of " & [CityName])
    >
    > Is it possible in this expression to apply bold format only for
    > [BornDate] ?
    >
    > thanks
     
  4. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Tom, do you think we should start mentioning that Access 2007 will be able
    to do this?

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
    news:94FD399F-F3CF-4656-85E1-A06C1B793509@microsoft.com...
    > No. Formats such as font, italic, bolding, etc. are an all or nothing
    > option
    > for textboxes, unless you are using a memo data type with a Rich Text
    > ActiveX
    > control.
    >
    > Two rich text controls worthy of mention include:
    > http://www.lebans.com/richtext.htm (Free) and
    >
    > http://www.fmsinc.com/products/memo/index.html (Not free).
    >
    >
    >> Trim([Name] &

    >
    > Please note that "Name" is a reserved word. You should avoid using
    > reserved
    > words for anything that you assign a name to in Access:
    >
    > Reserved Words in Microsoft Access
    > http://support.microsoft.com/?id=286335
    >
    > List of reserved words in Jet 4.0
    > http://support.microsoft.com/?id=321266
    >
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "jean.ulrich@snclavalin.com" wrote:
    >
    >> Hi
    >>
    >> I have a trim expression
    >>
    >> Trim([Name] & ", " & [FirstName] & ", " & "born on the " & [BornDate] &
    >> " in the city of " & [CityName])
    >>
    >> Is it possible in this expression to apply bold format only for
    >> [BornDate] ?
    >>
    >> thanks
     
  5. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Rats. Somehow the two links I posted for the Rich Text included an extra
    white space. These new corrected links should work:

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

    http://www.fmsinc.com/products/memo/index.html


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Tom Wickerath" wrote:

    > No. Formats such as font, italic, bolding, etc. are an all or nothing option
    > for textboxes, unless you are using a memo data type with a Rich Text ActiveX
    > control.
    >
    > Two rich text controls worthy of mention include:
    > http://www.lebans.com/richtext.htm (Free) and
    >
    > http://www.fmsinc.com/products/memo/index.html (Not free).
    >
    >
    > > Trim([Name] &

    >
    > Please note that "Name" is a reserved word. You should avoid using reserved
    > words for anything that you assign a name to in Access:
    >
    > Reserved Words in Microsoft Access
    > http://support.microsoft.com/?id=286335
    >
    > List of reserved words in Jet 4.0
    > http://support.microsoft.com/?id=321266
    >
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "jean.ulrich@snclavalin.com" wrote:
    >
    > > Hi
    > >
    > > I have a trim expression
    > >
    > > Trim([Name] & ", " & [FirstName] & ", " & "born on the " & [BornDate] &
    > > " in the city of " & [CityName])
    > >
    > > Is it possible in this expression to apply bold format only for
    > > [BornDate] ?
    > >
    > > thanks
     
  6. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Allen,

    Sure, if that is the case. I wasn't aware of this new functionality. I still
    have not downloaded the new beta, so I haven't been able to play with all the
    new features (or the beloved ribbon).


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Allen Browne" wrote:

    > Tom, do you think we should start mentioning that Access 2007 will be able
    > to do this?
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
     
  7. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Well, I doubt the original poster has Access 2007 yet, but in the new
    version, it will be possible to set the Text Format property of the text box
    to Rich Text, and set the Control Source to:

    =Trim([Name] & ", " & [FirstName] & ", " & "born on the <b>" &
    [BornDate] & "</b> in the city of " & [CityName])

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
    news:B94652EB-B358-4552-BA7B-E68E508FB9C7@microsoft.com...
    >
    > Sure, if that is the case. I wasn't aware of this new functionality. I
    > still
    > have not downloaded the new beta, so I haven't been able to play with all
    > the
    > new features (or the beloved ribbon).
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "Allen Browne" wrote:
    >
    >> Tom, do you think we should start mentioning that Access 2007 will be
    >> able
    >> to do this?
     
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