make the text in the field bold

[botilismus]

hi. I change text colour in a query field by using ![Red] for example. So how can I make a text in a field bold in a query?

[June7]

Don't think can. Use forms and reports and set formatting of controls.

Exactly where and how do you use ![Red]? Doesn't work for me in Format property.

[botilismus]

When you open design view in query, you can click on field which you want change colour then from Properties Window on right, write ![Red] on "Format" part. Then Save query and open it again.

[isladogs]

Well I never knew that you could add colour to query fields ....
Also works for Blue, White (!!!), Green, Cyan and Yellow in text fields using ![Colour] notation

EDIT:
For number fields, use e.g. #[Red] or [Blue]# instead
Date fields change colour but get 'converted' to long integer value;



Sorry but no idea whether some method exists for Bold as well.
However, of course dead easy to do in a form

[botilismus]

I mean make text fields bold. I have a query. I want to sent it excel with a button. While I sent it excel, I want that some text fields will be bold.

[June7]

Right, I tried on date and number fields when I posted my response. Confirmed this formatting works only on text field. Also works in table.

However, cannot do any other special effects on fields in table/query.

Tested export of table with color formatting. The formatting does not export.

[botilismus]

So how can I do that? With a vba code?

[isladogs]

@June
Strange that this is possible - I'd never heard of it before.
Not sure how useful it is but its there for anyone who needs it!
I also tried lots of other effects - bold/ italic / underline - all unsuccessfully

@botilismus
Thanks for teaching me something new!
You need to do the formatting in Excel after exporting

[botilismus]

You are welcome