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.
Using labels to write permanent paragraphs? (1 Viewer)
- Thread starter Newbie8
- Start date
But is it tall enough?
Which is what? You are probably using the wrong type of control. You are adding text to a label in design view, saving it and parts are missing?
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.
June7
AWF VIP
- Local time
- Today, 10:03
- Joined
- Mar 9, 2014
- Messages
- 5,470
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.
="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.
MajP
You've got your good things, and you've got mine.
- Local time
- Today, 14:03
- Joined
- May 21, 2018
- Messages
- 8,527
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
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')
format the textboxes to be like labels.
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 FunctionNow add some unbound text boxes and set to rich text
for the control source of the unbound text box do something like
=GetMessage('TheMessageName')
format the textboxes to be like labels.
MajP
You've got your good things, and you've got mine.
- Local time
- Today, 14:03
- Joined
- May 21, 2018
- Messages
- 8,527
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.
HiTechCoach
Well-known member
- Local time
- Today, 13:03
- Joined
- Mar 6, 2006
- Messages
- 4,357
I prefer to handle this with a simple select query to get the data stored in a table.
I like o use a table to store the text as MajP recommended.
I use a form to maintain the Rich Text data. You can use Access's built-in support for the Rich Text editing.
I prefer to use a subform to display the data. Using a basic select query to get the desired record.
With a subform/subreport, adding the same text on another form or on a report is very easy.
I like o use a table to store the text as MajP recommended.
I use a form to maintain the Rich Text data. You can use Access's built-in support for the Rich Text editing.
I prefer to use a subform to display the data. Using a basic select query to get the desired record.
With a subform/subreport, adding the same text on another form or on a report is very easy.
