Format concatenation

  • Thread starter Thread starter Gene Hora
  • Start date Start date
G

Gene Hora

I've formed an expression of FamName & DirectoryNames thusly:

[FamName] & "," & " " & [DirectoryNames]

and would like to format the expression in 12-pt and the FamName in Bold
weight, but I can only get the entire expression to appear in Bold. Is
there a simple way to do this, or does it require VBA programming?
 
I've formed an expression of FamName & DirectoryNames thusly:

[FamName] & "," & " " & [DirectoryNames]

and would like to format the expression in 12-pt and the FamName in Bold
weight, but I can only get the entire expression to appear in Bold. Is
there a simple way to do this, or does it require VBA programming?
Click to expand...

It is not do-able in Access as shipped.
You can purchase and install a RidhTextFormat control, or see
http://www.lebans.com
for Stephan Lebans' free version.
 
Gene,

Access controls only allow one type of font formatting per
control. There are some "addon" RTF controls available
that, I think, will do what you require. Have a look at
Stephen Lebans' site - www.lebans.com
I haven't used any of these myself ..... so from here on
you will need some assistance from others.

HTH,

Terry
 
I've formed an expression of FamName & DirectoryNames thusly:

[FamName] & "," & " " & [DirectoryNames]

and would like to format the expression in 12-pt and the FamName in Bold
weight, but I can only get the entire expression to appear in Bold. Is
there a simple way to do this, or does it require VBA programming?
Click to expand...

It is not do-able in Access as shipped.
You can purchase and install a RidhTextFormat control, or see
http://www.lebans.com
for Stephan Lebans' free version.
Click to expand...

I believe it's Stephan's MixedBold coding that you will need, not
necessarily the RTF control for this.

http://www.lebans.com/mixbold-plain.htm
 
Thanks to both Fred and Terry for the helpful advice. I'll follow up on
this. Fast response!

Terry said:
Gene,

Access controls only allow one type of font formatting per
control. There are some "addon" RTF controls available
that, I think, will do what you require. Have a look at
Stephen Lebans' site - www.lebans.com
I haven't used any of these myself ..... so from here on
you will need some assistance from others.

HTH,

Terry
-----Original Message-----
I've formed an expression of FamName & DirectoryNames thusly:

[FamName] & "," & " " & [DirectoryNames]

and would like to format the expression in 12-pt and the FamName in Bold
weight, but I can only get the entire expression to appear in Bold. Is
there a simple way to do this, or does it require VBA programming?


.
Click to expand...
Click to expand...
 
I know you didn't ask this question but to save you a little typing, you can
add the space with the comma,

[FamName] & ", " & [DirectoryNames]


| I've formed an expression of FamName & DirectoryNames thusly:
|
| [FamName] & "," & " " & [DirectoryNames]
|
| and would like to format the expression in 12-pt and the FamName in Bold
| weight, but I can only get the entire expression to appear in Bold. Is
| there a simple way to do this, or does it require VBA programming?
 
Thanks for pointing that out. I did find this out a little later when I put
my thinking cap on.
 
Back
Top