PDA

View Full Version : Multiple fonts in excel forms textbox



ccRider246
01-28-2010, 06:25 AM
Is it possible to use more than one font in an Excel Forms textbox? Specificly, I would like to use a bold font on a few lines of text within a single Forms textbox while leaving the balance of the text normal.

I am using XP with Excel 11.

nst1107
01-28-2010, 12:02 PM
You will need a rich text control for utilizing multiple sizes, fonts, etc.. Alternatively, you may be able to get away with using a combination of labels and textboxes to give a comparable effect.

ccRider246
01-28-2010, 12:20 PM
Thanks for your reply, Nate. In this case I can't use the combination of controls. The textbox holds results of a product quotation that varies every time a new quote is assembled. My users have requested that I bold the heading text in each section of the printed quote. I will just separate the sections with a dashed line. That will probably satisfy them. This is a forms based quotation tool using spreadsheets for the database.

I think I am going to have to build a db in access and write the app in vs to get the richtext controls needed for multiple fonts.

Thanks for your help.

nst1107
01-28-2010, 12:23 PM
Glad to help. Here's microsoft's take: http://support.microsoft.com/kb/838010

ccRider246
01-28-2010, 12:37 PM
Thanks. I should spend more time reading MS documentation. Very useful.

Chris