I have several permanent paragraphs written inside a label. In random areas not all words are showing. My label is wide enough to accommodate everything. I am assuming, I am using the wrong to tool to write permanent paragraph.
Text in a label or UNBOUND textbox can be 'permanent'. Words not showing doesn't make sense. Show example of this text and/or images and/or attach db for analysis. Follow instructions at bottom of my post.
I am basically to have a permanent message part of a form with bullet points and numbering. For example when you visit there a disclaimer at the bottom of page.
Sounds like you are trying to insert rtf type formatting in a label, which AFAIK, you cannot. You can with a textbox though, and make it look like a label.
Using an unbound textbox set for RichText for this would mean manually typing an expression in ControlSource property with text and HTML code tags:
="Test bold format <b>Text</b>"
Figuring out the HTML tags for your formatting with bullet points and indentation and line returns would be the challenge. Hence, my suggestion for an image.
If you want richtext simply build a table of messages with two fields. Make the message a memo and select rich text. Type in your messages and apply formatting.
tblMessages
messageName
message
On the form add a function
Code:
Private Function GetMessage(msgName As String) As String
GetMessage = DLookup("Message", "tblMessages", "MessageName = '" & msgName & "'")
End Function
Now add some unbound text boxes and set to rich text
for the control source of the unbound text box do something like
=GetMessage('TheMessageName')
The UDF is not needed, but I doubt many people can get the syntax correct directly in the control source. Lots of apostrophes and concatenation. The UDF makes it a lot easier to debug and reuse the code.