Forum Discussion
Merging formatted text boxes in MS Access
Hi All,
Is what you see in the first image below possible in MS Access? (See first image below, right side!) My goal is to merge multiple formatted text boxes into a single, coherent paragraph while retaining their distinct formatting. The software TLex exquisitely accomplishes this task as you can see.
But let's look closer at what's going on. On the left side, you have a data entry box where users can enter: definitions, translations, example sentences, notes, etc.
That info is then displayed on the right side of the screen. Notice how the styling, coloring, and formatting are all preserved. The text is not simply compiled into a list! It flows one sentence after the other, forming a coherent paragraph. THAT is what I'm trying to achieve.
I did make an attempt. The image below titled "My Version" clearly shows where I fell short. Yes, I maintained the text box formatting, but I was not able to get the text boxes to form a coherent paragraph. I also tried string concatenation, but that method does not preserve any of the text boxes' formatting.
So, has MS Access met its match? Can MS Access get text boxes to merge together while preserving the text boxes' individual formatting and form a coherent paragraph?
Hopefully, you can help. Look forward to your suggestions. Thanks in advance!
Hi,
In your first picture the formatting seems to be taken from the labels on the left side, not from the actual text boxes.
In your second picture it is not clear for me where the formatting comes from. I just see what could be Access text boxes but without much formatting like colors. So, what kind of settings, expressions etc. did you use in your attempt?
If you would use (Rich-Text) formatted text boxes as "source" text boxes, then you should be able to simply concatenate them with & for a combined result. e.g. as Control Source of RichTextbox3:
=[RichtTextbox1] & " " & [RichTextbox2]
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEKHi Karl,
You make valid points. I have tried [RichTextbox1] & “ “ & [RichTextbox1] and it did not work.
The resulting merged text field was not able to preserve the formatting of BOTH of the original text boxes that were concatenated.
This is illustrated in the images below.
The "Term" text box was clearly BLUE and BOLD, and the "PartOfSpeech" text box was clearly grey and italicized. When the two text boxes were concatenated, the second text box lost its formatting (this can be seen in the last image, which is Print Preview mode).
.
- The "Term" text box was clearly BLUE and BOLD, and the "PartOfSpeech" text box was clearly grey and italicized. When the two text boxes were concatenated,
The text boxes concatnated only values without format/style in fact.
