I also have a web front-end that views parts and pieces of the SQL data (more on that in a bit).īackground: the data in question resides in the SQL server in a varchar(2000) field. The ADP form in question has a "Text Box" object holding the data whose properties are set as: "Text Format" field = "Plain Text" (One record is I too am using Access 2010 using an ADP file w/ SQL 2008r2 backend. I am a newbie to Access VBA & web programming. Greetings all, I'm looking for the most straight forward solution (which could be data formatting, coding, both or none).
![use the default 12-point calibri font for unbound reports use the default 12-point calibri font for unbound reports](https://media.springernature.com/lw785/springer-static/image/chp%3A10.1007%2F978-1-4842-6555-0_6/MediaObjects/496733_1_En_6_Fig71_HTML.png)
![use the default 12-point calibri font for unbound reports use the default 12-point calibri font for unbound reports](https://thinkingthroughourfingers.files.wordpress.com/2017/12/font-menu.png)
Me.Event_Description.TextFormat = acTextFormatHTMLRichText Me.Event_Description.Value = strRichTextHeader & strExtractedText & strRichTextTrailer ' Build A Rich Text For The Default Calibri StrExtractedText = strExtractedText & Mid(Me.Event_Description, i, 1) If Mid(Me.Event_Description, 1, 1) "" Then ' If The Text Is Not in Rich Format, Do Usual Formatting Me.Event_Description.TextFormat = acTextFormatPlain
Use the default 12 point calibri font for unbound reports code#
You can, however, do your own Rich Text formatting in non-memo fields, but it is a lot of code :) Private Sub ChangeRichTextFont_Click() Note that Access Memo fields have built-in
![use the default 12-point calibri font for unbound reports use the default 12-point calibri font for unbound reports](https://online.anyflip.com/kdcd/imbg/files/mobile/1.jpg)
The Me.Event_Description is a standard text box with the "RichText" format selected as shown above. Here's a code snippet driven by a button that demonstrates setting a rich text box back to a standard format. I am not sure why you can't see the TextFormat property? The code below shows how I manually insert rich I have an application that uses a Rich Text box, and it is simply a matter of setting a textbox property as shown below (Access 2010).