Welcome to SPN

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

Sign Up Now!

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?
     

Share This Page