Conditional formatting in a query expression

[agarcia41]

I've created a scientific publications database. As part of the database I have queries which put together in a single new field [Complete citation] the authors, journal, year, etc.
I have a few reports using those queries and everything works fine.
Now I want in my report have the "journal" part of the [Complete citation] field in italics, but I don't know how to do that for a part of a field.
Thanks a lot.

Alberto

 

[meboz]

Once the fields are concatenated like that, I dont think you can change the formatting of a substring within that field, cos the formatting applied to the control, applies to the entire field.

 

[agarcia41]

I think so, but it would be possible to format it before join the strings in the query and keep the format intact?
Thanks for your response.

 

[meboz]

I dont think SQL cares about the format of string, thats something for the UI to take care of.

I think I know what it is your trying to do.

Have you though perhaps about generating the reports in Word instead of Access?

That way you can set the format on the merge field, and you can concatenate them nicely too.

 

[Mile-O]

I dont think SQL cares about the format of string, thats something for the UI to take care of.

It doesn't.

 

[Rich]

Access doesn't support variable formatting within a single string without a third party add in such as RichTextControl

 

[agarcia41]

Thanks you all. This has been very helpful!
I was thinking to combine Access reports I already have designed with some Word macros I can design to perform the formatting.