Format one field in bold in a trim expression

[jean.ulrich]

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

 

[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
__________________________________________

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

 

[Allen Browne]

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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
__________________________________________

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

 

[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
__________________________________________

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
__________________________________________

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

 

[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]

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])