SOLVED

Access Database - Entry Form Text formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2150616%22%20slang%3D%22en-US%22%3EAccess%20Database%20-%20Entry%20Form%20Text%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150616%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20would%20greatly%20appreciate%20your%20help%20and%20insight%20on%20this%20item%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20designed%20a%20database%2C%20and%20have%20created%20a%20number%20of%20forms.%20I%20have%20a%20team%20of%20staff%20entering%20data%20into%20the%20forms%20throughout%20the%20day.%20The%20information%20pertains%20to%20providers%20that%20work%20with%20our%20organizations%20meeting%20client%20needs.%20My%20staff%20need%20to%20be%20able%20to%20highlight%2Fcolor%20code%2FBolden%20the%20text%20pertaining%20to%20providers%20that%20they%20speak%20to%20-%20however%2C%20there%20is%20no%20generic%20rule%20that%20I%20can%20put%20in%20as%20formatting%20rule%2C%20I%20just%20want%20to%20be%20able%20to%20unlock%20that%20feature%2C%20so%20my%20staff%20can%20simply%20edit%20the%20text%20formatting%20whenever%20they%20need%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%20I've%20only%20seen%20conditional%20formatting%20-%20and%20there%20is%20absolutely%20no%20general%20rule%20that%20I%20can%20apply%2C%20as%20the%20formatting%20my%20staff%20will%20use%20is%20really%20across%20a%20spectrum%2C%20as%20they%20call%20providers!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20greatly%20appreciate%20any%20suggestions%20on%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2150616%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2150735%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Database%20-%20Entry%20Form%20Text%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150735%22%20slang%3D%22en-US%22%3EYou%20can%20set%20the%20field%20to%20RTF%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-or-delete-a-rich-text-field-9f86237d-dbbc-4a85-b12c-9d8dca824630%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-or-delete-a-rich-text-field-9f86237d-dbbc-4a85-b12c-9d8dca824630%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ERTF%20is%20a%20striped%20down%20version%20of%20HTML%2C%20and%20if%20you'll%20like%20all%20the%20power%20that%20HTML%20has%20to%20offer%20then%20look%20over%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.devhut.net%2F2019%2F10%2F11%2Fms-access-improved-html%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.devhut.net%2F2019%2F10%2F11%2Fms-access-improved-html%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I would greatly appreciate your help and insight on this item:

 

I have designed a database, and have created a number of forms. I have a team of staff entering data into the forms throughout the day. The information pertains to providers that work with our organizations meeting client needs. My staff need to be able to highlight/color code/Bolden the text pertaining to providers that they speak to - however, there is no generic rule that I can put in as formatting rule, I just want to be able to unlock that feature, so my staff can simply edit the text formatting whenever they need to.

 

Is this possible? I've only seen conditional formatting - and there is absolutely no general rule that I can apply, as the formatting my staff will use is really across a spectrum, as they call providers!

 

I would greatly appreciate any suggestions on this.

 

Thank you

2 Replies
best response confirmed by MovaridN (New Contributor)
Solution
You can set the field to RTF, see https://support.microsoft.com/en-us/office/create-or-delete-a-rich-text-field-9f86237d-dbbc-4a85-b12...

RTF is a striped down version of HTML, and if you'll like all the power that HTML has to offer then look over
https://www.devhut.net/2019/10/11/ms-access-improved-html/

@Daniel_Pineault 

 

Fantastic! It worked. Thank you so much!