How do I bold/italicize a string in a Module?

[PRD]

I am familiar with the ‘UCase’ keyword to convert a string to uppercase in a Module but I cannot seem to find a keyword to make a string Bold or Italics. Is there a way I can make a string both Bold and Italicized in a Module - Bold/Italicized? Thank you.

 

[Mr. B]

Depending on what you want to do with the string, you can set the Bold and Italicized properties of controls where the string value will be displayed, but you cannot set these values for the actual string.

 

[PRD]

Mr. B -

Thanks for your feedback. I work for a botanical garden where the scientific names of plants are italicized by convention. I am using the Module to perform data validation and was hoping to generate error messages which would then be passed back to a message area on a Form. It would have been nice to pass back an italicized name but I guess upper case will have to do. Thanks again for your help.

 

[boblarson]

You would need to be using a Rich Text control and a field in the table which supports rich text (Access 2007 or onwards otherwise you would need to use Stephen Lebans' RT Control).

 

[Mr. B]

If your results are going to be "passed back to a message area on a Form", then you would be using a Label control or a Textbox control to display the message on your form. If this is the case you can set the formatting of the control to display the message with the type of formatting you want. You may have to get a littel creative in the way you format one or more controls to actually display the message with the formatting you want. Just some thoughts.