Forum Discussion
Merging formatted text boxes in MS Access
Hi Karl,
I think I made some headway. (See pic on the left below.)
Yes, I technically concatenated several text boxes, each with its own formatting/coloring, etc. So that is a victory! Thank you so much. I can't tell you how many people thought this was impossible. Thanks for the link, too.
However, the changes made here only apply to the selected text. If I want to make a new entry, I have to format the text all over again and manually remove the <div> HTML tags to ensure the fields flow one after the other.
Given I will be entering hundreds, if not thousands of entries, this method would be too slow. However, I will keep using it for the time being as I continue to learn MS Access.
My goal, however, is to replicate some of the workflow happening in the TLex Software (See the right side of the pic). This software has been such a source of inspiration for me.
In TLex, you simply enter the info into the data entry text boxes, and the information is automatically displayed in its proper formatting without the need to manually select the text to change the color.
So, I suppose I'll save that venture for another day, given automating that process would likely require VBA, which I haven't learned yet.
But thank you for going on this journey with me, Karl.
Hi,
Well, as I said, there are potential workarounds that could fit better for you than the usual Rich Text thing. Here's one without VBA:
1 = Two textboxes bound to table fields, all without Rich Text.
2 = Two (hidden) textboxes with expressions that combine/concatenate formatting HTML tags and the content of the text fields. They also don't need to be set to Rich Text.
3 = The text box that concatenates the two hidden text boxes. This is the only one that needs to be set to Rich Text as it displays the formatting.
Servus
Karl
****************
Access News
Access Forever
Access DevCon
Access-Entwickler-Konferenz AEK