Format of Column Headings Crosstab

[bymarce]

I have a query that gets values from [Properties.Greek],
[Properties.Abbreviation], and [TestMethods.Abbreviation]. I have a
calculated field that puts them together with a comma or a space between
them. I want [Properties.Greek] to show up in symbol font and the others in
any regular font. How can I do this? Can I use format in the sql for this
purpose. My goal with this is to use this field as column headings in a
crosstab query. Thanks. Here is the sql:

SELECT Properties.Abbreviation AS Properties_Abbreviation, Properties.Greek,
TestMethods.Abbreviation AS TestMethods_Abbreviation, [Greek] & " " &
[Properties.Abbreviation] & ", " & [TestMethods.Abbreviation] AS
ColumnHeadings
FROM TestMethods INNER JOIN (Properties INNER JOIN PropertiesMethodsJunction
ON Properties.Property = PropertiesMethodsJunction.JProperty) ON
TestMethods.Method = PropertiesMethodsJunction.JMethod;

 

[Michel Walsh]

Formatting is not to be performed with SQL, in general. Here, you want to
use two fonts for the same 'control' (on a form or on a report), so it seems
you will either need TWO controls. If it is for a report, you can use two
text edit, side to side, the left one right aligned and with a font Symbol
and the right text control, left aligned, with a font "regular" and you will
split your string into the two text controls at the first coma position.
Well, that assumes you use a report. Otherwise, you may try to use a
RichText control (rather than the standard text control) which accept
multiple fonts inside the same text control. I never really used such a
control, though.


Vanderghast, Access MVP

 

[bymarce]

Thanks for the response. I found that I could insert a symbol into a word
document and copy it into my access field with other text.

Formatting is not to be performed with SQL, in general. Here, you want to
use two fonts for the same 'control' (on a form or on a report), so it seems
you will either need TWO controls. If it is for a report, you can use two
text edit, side to side, the left one right aligned and with a font Symbol
and the right text control, left aligned, with a font "regular" and you will
split your string into the two text controls at the first coma position.
Well, that assumes you use a report. Otherwise, you may try to use a
RichText control (rather than the standard text control) which accept
multiple fonts inside the same text control. I never really used such a
control, though.


Vanderghast, Access MVP

I have a query that gets values from [Properties.Greek],
[Properties.Abbreviation], and [TestMethods.Abbreviation]. I have a
calculated field that puts them together with a comma or a space between
them. I want [Properties.Greek] to show up in symbol font and the others
in
any regular font. How can I do this? Can I use format in the sql for
this
purpose. My goal with this is to use this field as column headings in a
crosstab query. Thanks. Here is the sql:

SELECT Properties.Abbreviation AS Properties_Abbreviation,
Properties.Greek,
TestMethods.Abbreviation AS TestMethods_Abbreviation, [Greek] & " " &
[Properties.Abbreviation] & ", " & [TestMethods.Abbreviation] AS
ColumnHeadings
FROM TestMethods INNER JOIN (Properties INNER JOIN
PropertiesMethodsJunction
ON Properties.Property = PropertiesMethodsJunction.JProperty) ON
TestMethods.Method = PropertiesMethodsJunction.JMethod;

 

[Michel Walsh]

Yes, as long as you use the same FONT, you can also use the Symbol system
tool ( with XP: START | All programs | Accessories | System Tools |
Characters Map ) .


Vanderghast, Access MVP

Thanks for the response. I found that I could insert a symbol into a word
document and copy it into my access field with other text.

Formatting is not to be performed with SQL, in general. Here, you want to
use two fonts for the same 'control' (on a form or on a report), so it
seems
you will either need TWO controls. If it is for a report, you can use two
text edit, side to side, the left one right aligned and with a font
Symbol
and the right text control, left aligned, with a font "regular" and you
will
split your string into the two text controls at the first coma position.
Well, that assumes you use a report. Otherwise, you may try to use a
RichText control (rather than the standard text control) which accept
multiple fonts inside the same text control. I never really used such a
control, though.


Vanderghast, Access MVP

I have a query that gets values from [Properties.Greek],
[Properties.Abbreviation], and [TestMethods.Abbreviation]. I have a
calculated field that puts them together with a comma or a space
between
them. I want [Properties.Greek] to show up in symbol font and the
others
in
any regular font. How can I do this? Can I use format in the sql for
this
purpose. My goal with this is to use this field as column headings in
a
crosstab query. Thanks. Here is the sql:

SELECT Properties.Abbreviation AS Properties_Abbreviation,
Properties.Greek,
TestMethods.Abbreviation AS TestMethods_Abbreviation, [Greek] & " " &
[Properties.Abbreviation] & ", " & [TestMethods.Abbreviation] AS
ColumnHeadings
FROM TestMethods INNER JOIN (Properties INNER JOIN
PropertiesMethodsJunction
ON Properties.Property = PropertiesMethodsJunction.JProperty) ON
TestMethods.Method = PropertiesMethodsJunction.JMethod;